DX Unified Infrastructure Management

  • Private Community
Back to discussions
Expand all | Collapse all

Listing the host name, IP and the Disk partitions for SNMP based device

  • 1.  Listing the host name, IP and the Disk partitions for SNMP based device

    Posted Jun 15, 2018 12:31 PM

    Hi All,

     

    We are monitoring the mix of devices with UIM robot and SysEDGE/SNMP.

    I can get the hostname, IP and Disk Partition (Target) information from s_qos_data using the below queries for UIM robot based monitoring devices

     

    select name, ip, os_type from CM_COMPUTER_SYSTEM where IP is NOT NULL and OS_TYPE in ('UNIX','Windows') --> To list server name and IP

    select source, target from s_qos_data where qos like '%QOS_DISK_USAGE%' --> to list server name and partition.

     

    How can I get this information for SNMP based monitoring devices?

     

    Thank you.

    Rajashekar



  • 2.  Re: Listing the host name, IP and the Disk partitions for SNMP based device
    Best Answer

    Broadcom Employee
    Posted Jun 17, 2018 07:41 PM

    Try the following.

     

    select cs.name, cs.ip, cs.os_type, qd.source, qd.target, qd.probe from CM_COMPUTER_SYSTEM cs join s_qos_data qd on cs.name = qd.source where qd.probe = 'pollagent' order by cs.name



  • 3.  Re: Listing the host name, IP and the Disk partitions for SNMP based device

    Posted Jun 18, 2018 06:36 AM

    Thank you David. It is working.