6.1 Querying Data and Generating Reports in Novell Audit

Novell Audit provides two tools to query events and generate reports: the Novell Audit iManager plug-in and Novell Audit Report (LReport).

The following sections provide more information on these tools:

6.1.1 The Novell Audit iManager Plug-in

The Novell Audit iManager plug-in is a Web-based JDBC* application that enables you to query MySQL* and Oracle* databases. All queries are defined in SQL.

iManager includes several predefined queries and it includes a Query Builder to help you define basic query statements. Of course, you can also build your own SQL query statements.

For complete information on defining and running queries in iManager, see the following sections in the Novell Audit 2.0 Administration Guide.

6.1.2 Novell Audit Report

Novell Audit Report is a Windows-based, ODBC-compliant application that can use SQL query statements or Crystal Decisions* Reports to query Oracle and MySQL data stores (or any other database that has ODBC driver support). You can define your own SQL query statements or import existing query statements and reports. Query results are returned in simple data tables; rows represent individual records and columns represent fields within those records.

For complete information on defining and running queries in Novell Audit Report, see the following sections in the Novell Audit 2.0 Administration Guide.

Identity Manager Reports

In Novell Audit Report, the term “reports” refers specifically to Crystal Decisions Report Template Files (*.rpt). Crystal Decisions Reports graphically summarize specific sets of log data in pie charts, bar charts, and so forth.

Identity Manager provides a number of Crystal Decisions Reports (*.rpt) that simplify gathering information on common operations performed in Identity Manager. These reports are included on the Identity Manager installation CD. For examples of these reports, see Section B.0, Identity Manager Reports.