Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: When Do I Run the DeleteOrphanedNames_x.x.x.bat?

App Control: When Do I Run the DeleteOrphanedNames_x.x.x.bat?

Environment

  • App Control Server: 8.0.x - 8.6.x
  • FilePath_Pruning_Scope_AllVersion.sql script
  • FilePathNamePruningBat_X.X.X.zip: All Versions

Question

When do I run the DeleteOrphanedNames_x.x.x.bat from the FilePathNamePruningBat_X.X.X.zip?

Answer

The DeleteOrphanedNames_x.x.x.bat (part of the FilePathNamePruningBat_X.X.X.zip package) should be used to clear orphaned filename and pathnames when the system has a high percentage of orphaned entries as determined by the 'FilePath_Pruning_Scope_AllVersion.sql'.

Additional Notes

  • A code change was added in Server version 8.7 to reuse unused rows. As such this script is not supported on 8.7 and Higher
  • So the' FilePath_Pruning_Scope_AllVersion.sql' script does NOT reveal anything in regards to the need for Reseed operation. This will show the number of orphaned filenames and pathnames in the DAS database tables only.

Related Content


Labels (1)
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎02-21-2019
Views:
284
Contributors