Query Generator Characteristics

 

The Query Generator is extremely flexible and provides comprehensive data filtering, selection of fields and field order, and sorting data.

 

iSecurity provides numerous example queries.

 

Creating a query takes just few minutes and requires no programming skills.

 

Same query can be run for:

• Single LPAR – The current one, or another one

• Multiple LPARs, noting the LPAR originating the transaction on each line and/or sorted by LPAR.

• Groups of LPARs or All LPARs

 

Each query can be run for by the scheduler for:

• Predefined periods such as Day, Week, Month

• Selected time ranges such as From Date/Time  - To Date/Time

• Last x minutes

 

Each query can produce for the same information in addition to the regular report three summary reports.

 

Each query can include an explanatory “handover” document along with the reports.

 

The query output can be displayed on the Green or GUI screen, or output as HTML, PDF, CSV (Excel), and OUTFILE (Output file). When using the GUI, the results of a query can also be directed to the Visualizer so BI methods can deal with the results.

 

The output can be sent by email, either one report at a time or as a group of reports together. Optional zip and password are available.

 

Alternatively, the query’s output can be kept on the IBM i for future observation.

 

Customers can set the product to either send or eliminate empty reports.

 

The subject of the email will say If it only contains empty reports. (Some auditors prefer to keep all reports, even if they are empty, to ensure that the definition of the report did not change.)