AppWorx, Dollar Universe and Sysload Community

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.

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