Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092bc7c442457007123ca0f)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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