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

[#1]

Environment

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

Objective

To run the FilenamePathnameReseed<Version>.bat file

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 Notes

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.
• Create a Full Database Backup - SQL Server

Related Content

App Control: How to Run Delete Orphaned Names .bat File