Help banner

Running Queries and Event Verifications

The Queries and Verifications tasks let you create, run, edit and delete queries and event verifications.

NovellŪ iManager uses queries to request information from MySQL* and Oracle* databases. All queries are defined in SQL*. Although you must be familiar with the SQL language to create SQL query statements, this is the most powerful and flexible query method.

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

To access the Queries task:

  1. Click the Roles and Tasks button on the iManager toolbar.

  2. Expand the Auditing and Logging role and select the Queries task.

    The Queries task page opens.

To access the Verification task:

  1. Click the Roles and Tasks button on the iManager toolbar.

  2. Expand the Auditing and Logging role and select the Verification task.

    The Verification task page opens.

Both the Queries and Verifications task pages are divided into two sections:

 

Creating Queries or Verifications

You can create two kinds of queries in iManager: manual queries and saved queries. Manual queries are simply queries that are not saved; they only run one time. All verification queries are saved. Saved queries and verifications are listed in the Queries list and can be run again and again against different databases.

To create a new manual query:

  1. In the Queries section, click Manual.

    The Manual Query page opens.

  2. In the Name field, enter a name for the query.

    This name appears in the query results' title.

  3. In the Query window, define the query statement.

    For basic information on building SQL queries, see the Novell Audit Administration Guide.

    HINT: You do not have to include a FROM clause in your query statement. iManager dynamically builds the FROM clause using the table specified in the database definition you select when you run the query. However, if the query statement does include a FROM clause, iManager queries the table defined in the query statement.

  4. When finished, click Run Query to run the manual query.

 

To create a new saved query or verification:

  1. In the Queries section, click New.

    The New Query or New Verification page opens.

  2. Define the query statement.

    or

    Define the event verification.

  3. When finished, click OK.

The query or verification now appears in the Queries list. Saved queries are stored in the User object you use to log in to iManager; therefore, they are not available to other users on the system.

 

Running Saved Queries or Verifications

To run a saved query or verification:

  1. In the Queries list, select the box next to the query or verification you want to run.

  2. Click Run Query or Verify.

iManager runs the selected query or verification and displays the results.

 

Editing Saved Queries or Verifications

You can edit any saved query or verification, including the predefined queries included with iManager. To edit a saved query or verification:

  1. In the Queries list, select the box next to the query or verification you want to edit.

  2. Click Edit.

    The Edit page opens.

  3. Modify the query fields.

    or

    Modify the verification fields.

  4. When finished, click OK.

 

Deleting Saved Queries or Verifications

To delete a saved query or verification, select the check box next to the query name and click Delete. The query or verification is removed from the Queries list.

Related Topics

Predefined Queries

Query Results

Novell Audit Help

A trademark symbol (®, ™, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.

Close