How to connect to the snmpcollector H2 Database to run queries

book

Article ID: 144937

calendar_today

Updated On:

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

UIM 8.x and 9.x
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