Database server monitor

Database server monitors a database using ODBC. The test verifies that the ODBC data source can be opened and accessed. The monitor can also execute a SQL query and compare the result to a predefined value.

  • System type: All
  • Category: Database

NOTE   Only monitor specific settings are documented here. See Standard monitor settings.

Basic tab

ODBC monitor properties

  • Datasource name - Name of the ODBC data source to be used to connect to the database. The datasource:
    • Be configured on the system hosting the gateway node of the target machine.
    • Must be an ODBC DNS System type data source.
    • Be 32 bit data source.
      • On 32 bit gateway host systems, run c:\Windows\System32\odbcad32.exe to configure the data source.
      • On 64 bit gateway host systems, run c:\Windows\SysWOW64\odbcad32.exe to configure the data source.
  • SQL query - Optional SQL query to perform.

ODBC account

  • Inherit credentials - If checked, inherits credentials from the asset. If blank, enter monitor-specific credentials.

    NOTE   For this monitor, uncheck this checkbox and enter monitor-specific credentials.

  • Username/password - Credential used to authenticate access for this monitor.
  • Fail if no rows - Check this option to make the monitor fail the test if the query returns no rows.
  • Data type - SQL query value is the only option currently supported.

Threshold settings

  • Value type - Type of value that the value queried from the database are compared with.
  • Compare operation - Specify how the queried value and the compare value should relate to each other for a successful test.
  • Compare value - Value to compare queried result with.