Query Generator Capabilities

 

Output

Screen, GUI, *PRINT, *PRINT1-9 (special user settings for print), PDF, HTML, CSV, OUTFILE (output file by fields)

 

Select (Filter)

The following TEST operations are supported:

  • EQ, NE, LE, GE, LT, GT

  • LIST, NLIST (Not LIST), 

  • LIKE, NLIKE (Not LIKE), 

  • START, NSTART (Not START),

  • ITEM, NITEM (Not ITEM), where a value is checked to see if it is in a group. Supported groups include:

    • *GRPPRF User is included in Group/Supplemental profile

    • *LMTCPB User Limit Capabilities

    • *SPCAUT User has a specified or any Special Authority

    • *TIMEGRP Time group – a weekly time table (e.g. after hours and weekends)

    • *USRGRP User is included in iSecurity/Firewall Group

    • General group Multiple groups ordered in classes such as Users, IPs, Libraries, and Objects. To simplify the setting of a rule, enter ITEM or NITEM as the TEST and press F4

  • PGM, NPGM (Not Program), a provided or user written program that return True or False. For example, whether the command in CD audit type was entered during elevated authority by Authority On Demand

  • To simplify the setting of rules, enter PGM, NPGM, ITEM, or NITEM as the test and press F4.

 

General groups can include generic names. *GENERIC should follow the named group.

You can combine tests with And or Or. And is the default. You can include the same field multiple times.

 

Sort

The following characteristics are available:

  • Multiple Fields

  • Ascending or Descending order

  • Break after change of a number of sort fields. A title is created containing the specified sort fields. All lines exclude these fields.

  • Report can include either all records or one record per key

 

Summary Sub Reports

While running the main report, data can be grouped in addition sub-reports. For example, when running on objects in a group of libraries, you can create counts of objects by owner or counts of objects by type, or sum objects sizes per library).

Up to 3 Summary Sub Reports can be processed simultaneously.

Data is Counted or a value of a field is Summarized.

Each such report classifies the data based on 1 to 3 fields.

Condition to print lines in a Summary Sub Reports.

The total number of records is always printed.

 

Explanation

Each report may carry a free format text that explains its contents. This reduces the effort of explaining the intention of the report and saves as its documentation.

 

Print of Filter

The filter used for the report can be printed.

 

Print of Header

A place for signing the report after inspecting it can be printed.