You can use the command line interface to groom audited events for registered SQL Server instances across your environment.

The groom operation supports the following syntax:

SQLcmCmd [-host CollectionServer] [-port number] groom {instance | -all} [numberofdaysold] [-nointegrity]


For example, to groom audited events older than 90 days for all registered instances without performing an integrity check, use the following command:

SQLcmCmd -host SERVER01 -port 5201 groom -all 90 -nointegrity



SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal

  • No labels