Run the "What is Executing Now" SQL Script

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Steps to determine what SQL statements are currently running within the DAS database, sometimes referred to as What's Currently Running or What's Executing Now.

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Resolution

1. Download the attached What_is_executing_now.sql
2. Log in to the application server hosting the Console as the Carbon Black Service Account. 
3. Open SQL Server Management Studio and connect to the SQL Server.
4. Click File > Open > File (CTRL+O) and select What_is_executing_now.sql
5. Click Query > Results To > Results to Text (CTRL+T).
6. Click Execute and once the script completes, right click the results and choose "Save Results As..."