AppWorx, Dollar Universe and Sysload Community

Expand all | Collapse all

Monthly Report of completed jobs grouped by Application

  • 1.  Monthly Report of completed jobs grouped by Application

    Posted 02-14-2018 02:52 PM
    I need to quickly pull together completed jobs grouped by Application, yet I do not find Application in the history table. 
    1. What tables are needed to merge this information with the job history 
    2. How do I merge the tables

    The application information for jobs in history are located in the aw_jh_view. The column is so_application. The rest of the information in the view is the same as the so_job_history table.


  • 2.  Monthly Report of completed jobs grouped by Application

    Posted 02-15-2018 09:11 AM

    This answered #1.

    How do I merge the tables to get desired results?



  • 3.  Monthly Report of completed jobs grouped by Application

    Posted 02-23-2018 01:50 PM

    You can query the aw_jh_view directly to get application along with all of the details found in the so_job_history table. There is no need to merge the tables as the view already does this.