App Control: How to Enable High Server Debugging Through SQL

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

To enable high debugging when the UI is unavailable.

Environment

• App Control (Formerly CB Protection) Server: All Versions
• Microsoft SQL: All Supported Versions

Resolution

1. Connect to the SQL server.
2. Open SQL Server Management Studio as either the service account or a SQL full admin. 
3. Run the following command: 

   use das; EXEC dbo.UpdateShepherdConfig 'DebugLevel', '6'

4. Collect 5-10 mins of data while reproducing the issue
5. Once collection is complete reverse the change by running:

   use das; EXEC dbo.UpdateShepherdConfig 'DebugLevel', '0'

6. Collect and attach the server log here: "\Program Files (x86)\Bit9\Parity Server\ServerLog.bt9"

Additional Information

All other steps on data collection for the App Control server can be found in https://community.carbonblack.com/t5/Knowledge-Base/Cb-Protection-Collecting-Logs-for-Troubleshooting-Cb-Protection/ta-p/62056