AppWorx, Dollar Universe and Sysload Community

Expand all | Collapse all

Hi All, I just want to know the process or technique by which we can fetch the report for Aborted Agents in a Month in Applications Manager UC4 version 8 Appworx. Kindly assist ASAP.

Jump to Best Answer
  • 1.  Hi All, I just want to know the process or technique by which we can fetch the report for Aborted Agents in a Month in Applications Manager UC4 version 8 Appworx. Kindly assist ASAP.

    Posted 10-03-2018 05:07 PM

    Hi All, I just want to know the process or technique by which we can fetch the report for Aborted Agents in a Month in Applications Manager UC4 version 8 Appworx. Kindly assist ASAP.



  • 2.  Re: Hi All, I just want to know the process or technique by which we can fetch the report for Aborted Agents in a Month in Applications Manager UC4 version 8 Appworx. Kindly assist ASAP.
    Best Answer

    Posted 10-04-2018 11:40 AM

    This looks like what you want to do.

    I use this sql to go back 72 hours on the history. So adjust as needed.

     

    select a.module,a.so_operator AS "AGENT",a.so_request_date AS "TIME REQUESTED",a.so_job_started AS "EXECUTION TIME",a.elapsed AS "ELAPSED TIME",a.so_job_finished AS "COMPLETED",a.so_status_name AS "STATUS",b.so_first_name||concat (' ', b.so_last_name) AS "USER"
    FROM
    AW_JH_VIEW a
    LEFT JOIN
    so_user_table b
    ON
    a.requestor = b.so_user_name
    WHERE
    a.so_status_name IN ('STARTED','STOPPED','ERRORS','MGRSTOPPED') -- add other statuses 
    AND to_date(a.SO_JOB_FINISHED) > sysdate -72/24 --adjust sysdate
    ORDER BY "EXECUTION TIME" DESC