TrueSight Middleware and Transaction Monitor: List all Monitored Queue Managers via SQL query

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Middleware Monitor


    COMPONENT:

    BMC Middleware and Transaction Management


    APPLIES TO:

    Middleware Management Middleware Monitoring TrueSight Middleware Monitor TrueSight Middleware Transaction Monitoring Application Transaction Tracing



    QUESTION:

    How to List all Monitored Queue Managers via SQL query?


    ANSWER:

    Use the following SQL.  Three columns are returned:

       
    1. networkHost - the Instance Path, which is the network host.
    2.  
    3. agentVersion - the agent platform and version.
    4.  
    5. queueManager - the name of the IBM MQ queue manager.
      
    select a.networkHost networkHost, a.agentVersion agentVersion, b.queueManager queueManager from (     select     a.inst_path networkHost,     b.attr_val agentVersion     from qp_obj_info a,     qp_nodes b     where     a.type_id = 21     and b.type_id = 1     and b.par_type_id = a.type_id     and b.par_lowoid = a.lowoid     and b.par_hioid = a.hioid     and b.name = 'AgentVersionString' ) a , (     select     fn_split_ipath(inst_path,1) networkHost,     fn_split_ipath(inst_path,2) queueManager     from qp_obj_info     where     monitored_flag = 'Y'     and state = 'C'     and type_id = 40 ) b where a.networkHost = b.networkHost order by 1, 2 ;
    Sample results:  
    MQA BMC MTM Extensible Agent Version 8.0.01.121 for Windows CLIENT_GATEWAY MQA BMC MTM Extensible Agent Version 8.0.01.121 for Windows CSQ1 MQA BMC MTM Extensible Agent Version 8.0.01.121 for Windows SERVER1 MQA BMC MTM Extensible Agent Version 8.0.01.121 for Windows SERVER2 MQB BMC MTM Extensible Agent Version 8.0.01.121 for Windows ESB
      




      

     


    Article Number:

    000148777


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles