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
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;
Copyright © 2013 CA.
All rights reserved.
|
|