App Control: How To Manually Run the DailyPruneTask Stored Procedure

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

 How to manually run the DailyPruneTask stored procedure.

Environment

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

Resolution

1. Login to the application server hosting the Console as the Carbon Black Service Account.
2. Open Microsoft SQL Server Management Studio and login using Windows Authentication.
3. Execute the following script to verify the task_id of the DailyPruneTask:

   use das;
   select * from dbo.scheduled_tasks where task = 'DailyPruneTask'

4. Execute the following script, by first adjusting the task_id found in Step 3:

   use das;
   EXEC dbo.DailyPruneTask @task_id = 'Step3_task_id'

Additional Information

• This task should not need to be executed manually, as it is scheduled to execute automatically.
• This task will require the Service Account correctly have permissions in the SQL Database.
• This task could take several hours to complete, and should only be executed during an appropriate maintenance window or as otherwise directed by Support.
• This task will prune files that meet all conditions for Zero Prevalence specified in the PurgeAntibodiesPeriodsDays parameter.