The Groom Audit Data Now window allows you to groom audited events currently stored in the Repository databases. Grooming permanently deletes any event that is older than the age limit you specify. To improve the Collection Server performance while maintaining audit data for later analysis, consider archiving your audit data.
Available actions
Generate Script
Creates a CLI command that includes your groom settings. You can save the command to a batch file or copy the command to another application. Use this command to schedule and automate your audit data maintenance through a third-party tool.
Available fields
SQL Servers
Allows you to select which SQL Server instance you want to groom. You can groom audit data for all registered SQL Server instances or for a particular SQL Server instance.
Grooming Options
Allows you to specify the age (in days) at which an audited event should be groomed and choose whether you want to skip the integrity check.
The Collection Server will not groom events that are younger than the specified age.
When you groom audit data, you can choose to check the integrity of the collected events. If the audit data for the selected SQL Server instance fails this integrity check, IDERA SQL Compliance Manager does not groom the data.
