MQ

 View Only

  • 1.  How to get a list of users connected to MQ Explorer

    Posted Fri December 02, 2022 04:41 AM
    Hello.
    Is there any way to get a list of MQ users that have connected/disconnected (user + IP) from a QMGR during a day using MQ Explorer?
    Thank you.

    ------------------------------
    rniew
    IT Spe
    IBM
    (49171) 722-9761
    ------------------------------


  • 2.  RE: How to get a list of users connected to MQ Explorer

    IBM Champion
    Posted Fri December 02, 2022 07:53 AM
    Edited by om prakash Fri December 02, 2022 07:54 AM
    from the UI you should be able to get the list.

    Select Queue Manager -> Right click -> Application Connections -> look for column "User ID", "Channel Name" , "Conn Name".

    This provides you details for the given time. Does not have historical info.




    ------------------------------
    om prakash
    ------------------------------

    Original Message


  • 3.  RE: How to get a list of users connected to MQ Explorer

    IBM Champion
    Posted Fri December 02, 2022 11:54 PM

    As @om prakash has already mentioned, it is possible to get the CURRENTLY connected details by using the DISPLAY CONN command, which can be done through MQ Explorer.

    To get information about connections that have already disconnected, you cannot use a current status command such as DISPLAY CONN, you must use something that collects historical data. IBM MQ Queue Managers can be configured to collect such data. It is called Accounting and Statistics data. I think if all you want is a list of the User IDs and IP addresses of applications that have connected to a queue manager during a day, you could simply turn on Accounting MQI data.

    Here is some additional reading material about Accounting data for you.

    In short though, while MQ Explorer can help you to enable Accounting data on your queue manager, it cannot let you view the collected data.

    Cheers,
    Morag​



    ------------------------------
    Morag Hughson
    MQ Technical Education Specialist
    MQGem Software Limited
    Website: https://www.mqgem.com
    ------------------------------

    Original Message


  • 4.  RE: How to get a list of users connected to MQ Explorer

    Posted Mon December 05, 2022 04:23 AM
    Thank you!

    ------------------------------
    rniew
    IT Spe
    IBM
    (49171) 722-9761
    ------------------------------

    Original Message


  • 5.  RE: How to get a list of users connected to MQ Explorer

    IBM Champion
    Posted Mon December 05, 2022 05:03 PM
    If you want a vendor solution, you should look at MQ Channel Connection Inspector.

    MQ Channel Connection Inspector is a solution that allows a company to track and/or audit what information a client application or remote queue manager is exchanging with the local queue manager when a connection is made.  i.e. Date, Time, UserId, IP address, SSL/TLS, etc.  All information is logged to an audit file (CSV format) and can be reviewed whenever you want.

    Regards,
    Roger

    ------------------------------
    Roger Lacroix
    CTO
    Capitalware Inc.
    London ON Canada
    https://capitalware.com
    ------------------------------

    Original Message