snmpcollector - pull a list of all devices where a template is deployed and what monitoring is enabled on those devices

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I want to get a list of sources, what template is applied to them, and what items are enabled for polling.

Environment

Release : UIM 20.3/ 20.4

Component : UIM - SNMPCOLLECTOR

Resolution

- Install Java and h2 DB Console http://www.h2database.com/h2-setup-2017-06-10.exe
- grab a copy of the last backed up database from the snmpcollector directory and copy it to the place where you installed the database viewer (something like c:\test), and extract it there
- open the database console and set the path to the following:

There is no password

-The following will give you a list of the data that you are looking for.

SELECT c.displayname, a.metricname, count(a.metricname), a.metricfamilyid, b.hostname, z.templatename
FROM METRICSTATE as a
JOIN SNMPDEVICE as b
ON a.parentdeviceid = b.deviceid
JOIN COMPONENTGROUP as c
ON a.metricfamilyid =c.metricfamilyid
JOIN ATTRIBUTION as z
ON z.Id=a.attribution_id_oid
group by c.displayname, a.metricname, b.hostname, a.metricfamilyid order by count(*) desc;

Example output:

As for exporting, you will have to just grab and go as it were. There is no export facility in the application.

Additional Information

Note: In v4.06, and possibly a few previous versions to it, you will likely need to change the procedure to get into the database:

- Install Java and h2 DB Console http://www.h2database.com/h2-setup-2017-06-10.exe
- Stop the snmpcollector probe
- execute the dbconsole.bat file in the snmpcollector directory

Once in you can run the above query.

Be sure to close both the command window and the web windows that are created after the requisite data has been retrieved, otherwise the probe will not be able to start up.