You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  • No labels