Hello,
I'm using the ucybdbrt reporting tool in AWA. Trying to get the last date ran for jobs. How do I get last date used on the report? Please see below the xml file being used and advise. When I execute the report the last use field is blank and the jobs are running daily.
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<QUERY version="12.2.">
<file css="Standard.css" type="csv">E1MM_IP_Report.csv</file>
<client>500</client>
<max_rows>10000</max_rows>
<source>DEFINITION</source>
<selection>
<include name="JOB_TYPE" value="R3"/>
<include name="OBJECT_TYPE" value="JOBS"/>
<include name="OBJECT_NAME" value="*E1MM*"/>
</selection>
<output order="ascending" sort="PARENT_JOBPLAN_NAME">
<field name="PARENT_JOBPLAN_NAME"/>
<field name="PARENT_JOBPLAN_CALENDAR_KEYWORD"/>
<field name="PARENT_SCHEDULE_START_TIME"/>
<field name="OBJECT_NAME"/>
<field name="OBJECT_TYPE"/>
<field name="R3_ACTIVATE_REPORT_REPORT"/>
<field name="R3_ACTIVATE_REPORT_VARIANT"/>
<field name="OBJECT_TITLE"/>
<field name="ARCHIVE_KEY1"/>
<field name="ARCHIVE_KEY2"/>
<field name="LAST_USE_DATE"/>
<field name="EARLIEST_STARTTIME"/>
<field name="JOB_CONTENT"/>
<field name="SAP_USER"/>
<field name="PARENT_SCHEDULE_NAME"/>
</output>
</QUERY>
Thanks,
Patrice Harrison