Use the CLI to verify audit data integrity

You can use the command line interface to verify and resolve the integrity of audited events for a specific registered SQL Server instance.

The checkintegrity operation supports the following syntax:

SQLcmCmd [-host CollectionServer] [-port number] checkintegrity instance [-fixintegrity]

For example, to verify the integrity of audited events for the test01\STD_SQL_2005 registered instance, use the following command:

SQLcmCmd -host TEST01 -port 5201 checkintegrity TEST01\STD_SQL_2005