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:
Click the Roles and Tasks button on the iManager toolbar.
Expand the Auditing and Logging role and select the Queries task.
The Queries task page opens.
To access the Verification task:
Click the Roles and Tasks button on the iManager toolbar.
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:
In the Database section, select the database you want to query or verify. Using the icons to the right of the Database drop-down list, you can also create, edit and delete database definitions.
The Queries section allows you to define saved and manual queries, or event verification queries. The Queries list contains all the saved queries or event verifications stored on your user object.
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.
In the Queries section, click Manual.
The Manual Query page opens.
In the Name field, enter a name for the query.
This name appears in the query results' title.
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.
When finished, click Run Query to run the manual query.
To create a new saved query or verification:
In the Queries section, click New.
The New Query or New Verification page opens.
or
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.
To run a saved query or verification:
In the Queries list, select the box next to the query or verification you want to run.
Click Run Query or Verify.
iManager runs the selected query or verification and displays the results.
You can edit any saved query or verification, including the predefined queries included with iManager. To edit a saved query or verification:
In the Queries list, select the box next to the query or verification you want to edit.
Click Edit.
The Edit page opens.
Modify the query fields.
or
Modify the verification fields.
When finished, click OK.
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.
A trademark symbol (®, , etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.