How to connect to the snmpcollector H2 Database to run queries

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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?

Environment

Release: Any UIM version
snmpcollector 3.x and 4.x

Resolution

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