AE DB Reporting Tool

Task Evaluations

The utility AE DB Reporting Tool can be used to query tasks in your AE system.

Results are supplied as a report file.
You can query:

Object contents
Future executions
Past executions

You can define the contents and dimensions of your queries. For example, you can list all jobs that were processed in a particular period of time or were created by a particular user. Queries always refer to one client.

Any number of queries can be defined.

Usage

The utility can be used via its graphical interface or in batch mode. The interface serves to generate and store evaluation definitions (queries). Subsequently, the utility can be started by using start parameters and the evaluation reports can be created. Data is retrieved from the client in which the query is defined. If this should be done regularly, Automic recommends using an AE job which calls the utility. In doing so, the further processing of report files becomes even easier. The formats CSV and HTML are available. A style sheet of your choice can be specified for HTML, which is then integrated in the report file.

Important Notes

Extensive queries require more time and affect performance negatively.
AutoForecast records are required for querying future executions.
AE Script considers only lines in the !Process tab of Time events which contain the script function ACTIVATE_UC_OBJECT.
If an Include object is not available in the client to be queried, it is searched for in system client 0000.
Script variables and Variable objects are not queried.
Ensure that the general entry for agent specifications (e.g. <WIN>) is selected in objects when setting the host using the script statement :PUT_ATT. Otherwise, the result can be a distorted one because it is not possible to see in which objects the host was changed.
The time and date entries in the AE database comply with the UTC time zone. For the evaluations, this data is converted to the time zone of the client in which the query is defined. It it does not include time-zone specifications, the system uses the time zone of client 0.