How can I connect to the snmpcollector H2 Database to run quries?
book
Article ID: 144937
calendar_today
Updated On:
Products
NIMSOFT PROBESDX 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