How can I access monitoring database to select certain data or make bulk changes to monitor properties?

You can access monitors data with isql.exe utility (shipped with our software distribution), from both remote and local computer, from both Windows and Linux. The data can be obtained in CSV format, and used afterwards to generate Excel charts, calculating response time variation with a custom script and so on.

Alternate means to access database is to use an ODBC driver for Firebird. Please keep in mind that we only supply database schema upon a user's request.

To perform a remote access, one should use credentials from [Database] section in nms.ini file (located in

"C:\ProgramData\IPHost Network Monitor"

folder). Default DB password is 'masterkey'.

Monitoring database is an ordinary Firebird database and thus can be accessed with such tools as "EMS SQL Manager for InterBase/Firebird" or by using isql.exe command line utility. Executing the "CONNECT" command like the following one:

C:\Program Files\IPHost Network Monitor\firebird\bin>isql.exe
Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT 'localhost/3055:C:\ProgramData\IPHost Network Monitor\data\nms.fdb' user 'SYSDBA' password 'masterkey';
Database: 'localhost/3055:C:\ProgramData\IPHost Network
Monitor\data\nms.fdb', User: SYSDBA
SQL> SELECT count(*) FROM monitors;

COUNT
=============
       107

To obtain data in CSV format once can use the following SQL query:

SELECT
   '"' || HOSTS.IP ||
   '","' || RESULT_RAW.WHEN_ ||
   '","' || RESULT_RAW.PERFORMANCE || '"'
FROM
   MONITORS
   INNER JOIN HOSTS ON (MONITORS.HOST_ID = HOSTS.ID)
   INNER JOIN RESULT_RAW ON (MONITORS.ID = RESULT_RAW.MONITOR_ID)
WHERE
   HOSTS.DISPLAY_NAME = 'hostname'
   AND RESULT_RAW.PERFORMANCE IS NOT NULL
ORDER BY
   RESULT_RAW.WHEN_;

Related Topics:
SOA monitoring