UIM - Gather SNMPCOLLECTOR device attribute information

book

Article ID: 211268

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

We need to access the information on all the devices present in the snmpcollector.

Where can I get this information from the UIM Database?



Environment

Release : UIM 9.x / 20.3

Component : SNMPCollector version 3.x and later

Resolution

SNMPcollector maintains its own DB. 

You can access this DB 

going to:

http://<snmpcollector_ip>:9715/database

 

The first screen is an authentication page with several parameters.  Just click "Connect" without changing anything.

**This is a relational database and we strongly discourage changing values here unless specifically instructed to do so by Support.**

 

 

 

 

If you need to find a specific device attribute:

 

Identify the ID of the devide:
SELECT * FROM SNMPDEVICE 

And then:

SELECT * FROM SNMPDEVICE_ATTRIBUTES where ID_OID = '<id_from_query_above>'

Additional Information

Related KBs:

UIM - Access snmpcollector DB
https://knowledge.broadcom.com/external/article?articleId=10315

How can I connect to the snmpcollector H2 Database to run quries?
https://knowledge.broadcom.com/external/article?articleId=144937

Attachments