Automic Workload Automation

 View Only
  • 1.  Reporting Tool

    Posted Oct 23, 2020 04:55 AM

    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



  • 2.  RE: Reporting Tool

    Posted Oct 26, 2020 09:49 AM
    Do you have the option for LAST_USE turned on?