How can I connect to the snmpcollector H2 Database to run quries?

book

Article ID: 144937

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

I would like to be able to run SQL queries on the snmpcollector H23 database to verify the information I have setup.
How can I 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.
4)  Open DOS prompt
5)  cd /probes/network/snmpcollector
6) 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
https://knowledge.broadcom.com/external/article?articleId=10315

UIM - Gather SNMPCOLLECTOR device attribute information
https://knowledge.broadcom.com/external/article?articleId=211268