Scenarios › Export the Archived Databases into an RDBMS › Export Archived Databases into an RDBMS › Validate the Exported Event Count

Validate the Exported Event Count

You can use the ValidationQueries.sql queries to validate the event count of an exported archived database against the event count that is stored in the CA User Activity Reporting Module server. The ValidationQueries.sql file contains a query for each exported archived database.

Follow these steps:

1. Navigate to the following location from the console:

   /opt/CA/LogManager/DBExportService
   

2. Open the ValidationQueries.sql file.
3. Copy the query for the archived database you want to validate and execute it in your RDBMS.