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.