Novell Doc: Novell BorderManager 3.9 Administration Guide - Viewing Events in Novell Audit Report

5.3 Viewing Events in Novell Audit Report

Novell Audit Report is a Windows-based, ODBC-compliant application that can use SQL query statements or Crystal Reports* to query Oracle and MySQL data stores (or any other database that has ODBC driver support).

To generate a simple query:

In the Novell Audit Report Workspace, click the Events tab, then expand the BorderManager folder. This list contains all predefined BorderManager events. Double-click any event in the list to view event properties.
To query for events, right-click the event in the Workspace and select Define Query.
When the Query Expert appears, specify a time frame and verify the event.
To run the query, select the Query tab in the Workspace, right-click the query name, then select Run.

Queries can also be created using the following SQL statements:

To view all logs, enter the following command:

select * from log;
To query for all common logs of Novell BorderManager, enter the following command:

select * from log where EventID=0x00040001;
To query for all extended logs of Novell BorderManager, enter the following command:

select * from log where EventID=0x00040002;
To query for all Rule Hit logs of Novell BorderManager, enter the following command:

select * from log where EventID=0x00040004;