App Control: How to Run Filename Pathname Reseed .bat File
search cancel

App Control: How to Run Filename Pathname Reseed .bat File

book

Article ID: 286155

calendar_today

Updated On:

Products

Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

To run the FilenamePathnameReseed<Version>.bat file

Environment

  • App Control Server: 8.0 - 8.6
  • Microsoft Windows Server: All Supported Versions

Resolution

  1. Login to the App Control database server
  2. Confirm there is a recent full backup of the das database
  3. Execute the 'FilePath_Pruning_Scope_AllVersion.sql' script
    • Results will validate percentage of orphaned files/paths
  4. Open Services.msc
  5. Stop the "Carbon Black App Control Reporter" and "Carbon Black App Control Server" services in services.msc
    • These services were formally named "CB Protection Reporter" and "CB Protection Server"
  6. Extract 'FilenamePathnameReseed_X.X.X.zip'
  7. Double click the FilenamePathnameReseed_X.X.X.bat
  8. Script will prompt for name of the SQL server.
    • This needs to match how it is seen in the Objects Panel of the SQL Server Management Studio, e.g, Instance\Servername Note: if unsure then open SSMS, right-click on the top tree node > properties > (copy and paste what's in the 'name' field) 
  9. Let the .bat script complete.
  10. Once complete, copy the output from the command window into a text file and save it. 
  11. Restart the "Carbon Black App Control Reporter" and "Carbon Black App Control Server" services in services.msc
  12. Rerun the 'FilePath_Pruning_Scope_AllVersion.sql'
  13. Provide the results of step 3, 10, and 12 to Carbon Black Support.

Additional Information

Warnings:
  • Do not use this script without the help from Carbon Black Support.
  • A new version of this script is required for versions 8.7 and higher
  • Cancelling the reseed after starting will leave the database severely corrupted and require a restore. Contact Support if any questions or concerns come up.
  • If Unified Management server is in use, navigate to the https://<UMServer>/support.php page on the UM Master and at the bottom of the page uncheck the Validate Rules checkbox 
  • FilenamePathnameReseed_X.X.X.bat is version specific, ensure the proper version is being ran
  • FilePath_Pruning_Scope_AllVersion.sql is not version specific
  • Due to the creation of temporary tables, please verify that there is at least twice the free space of the current DAS database size.Not doing so will result in database corruption and require a restore.
  • This process is time consuming and can take anywhere from a few hours to several days in some scenarios.
  • https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15
Powered by Wolken Software