Implementation Guide › Installing CA User Activity Reporting Module › Install the ODBC Client › Test Server Retrieval from the Database

Test Server Retrieval from the Database

Use this test query to determine whether an ODBC client application is able to retrieve data from a CA User Activity Reporting Module event log store using the established database connection. This procedure uses the same ISQL utility you used to test the ODBC connection.

Note: Do not copy and use the SQL queries provided in the CA User Activity Reporting Module queries and reports to test your ODBC connection. Those SQL statements are only for the CA User Activity Reporting Module server to use with the event log store. Build your ODBC SQL queries using standard constructs according to the ANSI SQL standard.

To test the server component data retrieval

1. Access a command prompt and navigate to the directory where you installed the ODBC client.
2. Start the ISQL utility, odbcisql.exe.
3. Enter the following SELECT statement to test retrieval from the event log store:

   select top 5 event_logname, receiver_hostname, SUM(event_count) as Count from view_event where event_time_gmt < now() and event_time_gmt > timestampadd(mi,-15,now()) GROUP BY receiver_hostname, event_logname;
   

More information

SQL Support Limitations

Supported SQL Functions