How to refer devices which polled specific Vendor Cert

Document ID : KB000010608
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

It is possible to refer what kind of Metric Family and Vendor Certification are allocated in specific devices from Monitored Devices screen 

However, out-of-box Dashboard does not provide the reverse-reference to tell which devices are polled by certain Vendor Certification.

So user had to make it.  Here, there is a command level method to see it. 

Environment:
RedHat: 6.x
Instructions:

For example, try to retrieve "Cisco Switch Engine". 

 

001.png

 

It is necessary to convert into item_type name from the display name of the Vendor Certification. 

So, please output the following REST Web service and search for the Vendor Certification display name in it.

http://<DA>:8581/typecatalog/certifications/snmp/

 

        <MIB>CISCO-SWITCH-ENGINE-MIB</MIB>

        <DisplayName>Cisco Switch Engine</DisplayName>

        <Expressions>

            <ExpressionGroup

                destCert="{http://im.ca.com/normalizer}NormalizedSwitchingEngineInfo" name="CiscoSwitchEngineDS">

                <Expression destAttr="Indexes">Index</Expression>

 

Execute following command in the Data Repository server with inserting above item_name (destCert).

 

[root@DR]# /opt/vertica/bin/vsql -U dauser -w dapass -c "select * from v_item where item_id in (select item_id from v_item_facet where facet_qname = '{http://im.ca.com/normalizer}NormalizedSwitchingEngineInfo');"

 

 item_id |          item_type          |               name               | description | tenant_item_id

---------+-----------------------------+----------------------------------+-------------+----------------

    4303 | {http://im.ca.com/core}Item | Sim30529:CATEST-Cisco-N7K |             |              1

(1 row)

 

Additional Information:

If you want to export the output by the CSV format, execute the following command.

[root@DR]# /opt/vertica/bin/vsql -U dauser -w dapass -c "select * from v_item where item_id in (select item_id from v_item_facet where facet_qname = '{http://im.ca.com/normalizer}NormalizedSwitchingEngineInfo');" -A -F ',' > Output_file_name