Administration Guide > Utilities > AE DB Reporting Tool > XML Files of Queries

XML Files of Queries

Queries are stored in the sub-folderTop level entities such as Environment, Deployment Target, Activity, … are stored in folders. The permissions a user has on an entity depend on the permissions that are set on the folder for the entities. "queries" in the form of XML files.

The utility generates the XML files. No manual adjustment is required for the entries.

Parameters

Description

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

XML Declaration

<QUERY version="Automation EngineThis component drives an Automation Engine system and consists of different types of server processes. version">

Automation Engine version of the utility which created the query file

<file css="style sheet" type="format">reportA report provides more detailed information about a task's execution or a component. file</file>

Evaluation report

"style sheet" = directory and name of the style sheet that should be integrated in the HTML file

"format" = file format of the report
Allowed values: "HTML" and "CSV"

Report file = directory and name of the file in which the evaluation information is written. The directory must be an existing one.

<clientA closed environment within an Automation Engine system where you can create and run objects. A client name consists of a 4-digit number that must be indicated when a user logs on to the Automation Engine system. Users and their rights are also defined in clients. A particular Automation Engine object type.>client</client>

Client in which the evaluation should be made

<max_rows>lines</max_rows>

Maximum number of lines the report can have

Allowed values: "1" - "99999"

<source>query type</source>

Evaluation area

Allowed values: "DEFINITION", "FORECAST" and "STATISTIC"

<reference>

Period for statistical and forecasting evaluations

<date>date</date>

Date in the format YYYY-MM-DD or the special value TODAY. If TODAY is used, the utility uses the latest date for report creation.

<offset>time range</offset>

Number of hours to be added to the date (forecasts) or subtracted from it (statisticsThis is a list of a task's previous runs.). Therefore, this value includes an algebraic sign (+/-).

</reference>

Ending of the XML element <reference>

<selection>

Beginning of the elements about evaluation criteria

<include name="criterion" value="value" />

The individual evaluation criteria are listed as a value pair.

</selection>

Ending of the XML element <selection>

<output order="order" sort="sorting">

Beginning of the elements for the output columns in the report

"order" - ascending or descending order
Allowed values: "ascending" and "descending"

"sorting" - column determining how elements are sorted

<field name="column" />

Output columns to be included in the report

</output>

Ending of the XML element <output>

</QUERY>

Ending of the XML element <QUERY>

Example of a Query File

<?xml version="1.0" encoding="UTF-8" ?>
<QUERY version="11.0.0">
<file type="CSV">Output_SAPjobs.html</file>
<client>0098</client>
<max_rows>1000</max_rows>
<source>DEFINITION</source>
<selection>
<include name="OBJECT_TYPE" value="JOBS" />
<include name="JOB_TYPE" value="R3" />
<include name="OBJECT_NAME" value="*T01*" />
</selection>
<output order="ascending" sort="OBJECT_NAME">
<field name="OBJECT_NAME" />
<field name="LOGIN" />
<field name="SAP_CLIENT" />
<field name="SAP_USER" />
<field name="MODIFIED_DATE" />
<field name="LAST_USE_DATE" />
</output>
</QUERY>

 

See also:

Evaluations about Tasks in the AE system
Graphical Interface of the Reporting Tool

Creating Evaluation Reports

Start Parameters

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH