Administration Guide › Accessing Collected Events with ODBC and JDBC › Use Crystal Reports to Access the Event Log Store with ODBC

Use Crystal Reports to Access the Event Log Store with ODBC

You can use the ODBC access feature to query CA User Activity Reporting Module event data from a third party reporting tool like BusinessObjects Crystal Reports. After you complete the required installation and configurations, you are ready to prepare and send ANSI SQL standard queries to the CA User Activity Reporting Module event log store.

The database schema for the event log store is the common event grammar (CEG). The CA User Activity Reporting Module online help contains a CEG reference component to help you create queries. You can also review the underlying SQL statements for the out-of-the-box queries, but use ANSI SQL to access the database from outside CA User Activity Reporting Module.

To access event data from Crystal Reports

1. Complete the prerequisite installation and configuration tasks.
2. Start Crystal Reports and access the Standard Report Wizard.
3. Create an ODBC connection in the Data dialog, and select the ODBC datasource you created in the Windows Control Panel.

   

4. Use the Add Command functionality to create a query in the SQL entry area.

   For example, you could create the following query:

   SELECT source_username as source_username , SUM(event_count) AS FUNC_SUM_event_count FROM view_event WHERE  event_result = 'F' GROUP BY source_username ORDER BY FUNC_SUM_event_count DESC;
   

5. Click OK to complete the query entry.

   A report template appears in which to place the data columns returned by the query.

6. Drag and drop the fields from the Field Explorer, in the upper right corner, into the report template as columns.

   Running the query displays the values associated with the fields. You can use Crystal Reports to create any visualization or customization you need.

7. (Optional) Compare report results against the out-of-the-box report, "Failed Activity by Performer."