The Queries option in the Auditing and Logging plug-in allows you to use SQL queries to retrieve information about the events stored in the database. The following sections explain how to configure and use this feature.
In the Administration Console, click> .
Fill in the following fields:
JDBC Class: Specify.
JDBC URL: Specify.
Replace <IP address> with the IP address of your MySQL server, for example: .
Store Password: Select this option so that the password is stored.
Continues with Section 8.3.2, Configuring the Query Event List and Display.
On the Query Options page, click thetab.
Click the Jwilson1 Logging Server.icon, and find the Logging Server object that has the host name of your Administration Console prepended to it, for example
For this example, the Novell Audit Secure Logging Server DN field displays the following name:
Jwilson1 Logging Server.Logging Services
Selectfor the .
Continue with Section 8.3.3, Performing a Query.
Select, then click .
A display similar to the following should appear.
For more information about the fields that are possible on each event row, see Novell Access Manager 3.0 SP4 Administration Guide.
For more information about how to use queries and create your own, see the Novell Audit 2.0 Administration Guide.