search cancel

How to connect to the snmpcollector H2 Database to run queries


Article ID: 144937


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


Would like to be able to run SQL queries on the snmpcollector H23 database to verify the information  setup.
How to connect to this database and do that?


UIM 8.x and 9.x
snmpcollector 3.x and 4.x


1) Deactivate the snmpcollector probe
2) Add UIM JRE path (Example, C:\Program Files (x86)\Nimsoft\jre\jre8u102\bin)  to PATH variable.
3) Open DOS prompt
4) cd /probes/network/snmpcollector
5) Execute dbconsole.bat

This will open a web browser window where you can then enter in SQL queries against the H2 database

Additional Information

Related KBs:

UIM - Access snmpcollector DB

UIM - Gather SNMPCOLLECTOR device attribute information