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
SQL Compliance Manager audits all activity on your server. Learn more > >
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal