AutoSys Workload Automation

SQL for all Agents of a System

  • 1.  SQL for all Agents of a System

    Posted Mar 01, 2019 05:04 AM

    Hello,

     

    i'am currently working on a Job to give me all Agents that are known to a UC4 AWA System and their assigment.

     

    I have two SQLI Objects that give me most of the Agents.

     

    One for all Agents that have a Client assignet and their Client assigment:
    select ACTEX_HOST, HACL_CLIENT from ACTEX, HACL
    where HACL_OH_IDNR = ACTEX_OH_IDNR

     

     

    And the secound one for all known Agents by the MQSRV:

    select MQSRV_NAME from MQSRV
    where MQSRV_TYPE = 8

     

    The Problem is there are some that still don't show up.

    Where am i missing something?

     

    Best Regards