Next Topic

Previous Topic

Book Contents

SQL_Value Test Parameters

Returns a numeric result that is compared against the configured thresholds. The SQL query specified must return a single column with numeric value. Standard JDBC drivers are included for the most commonly used databases: DB2, Microsoft, Oracle, Sybase, MySQL, PostgreSQL.

Note: This monitor is separate from monitoring the internal metrics of databases, which is done using WMI or SNMP.

The following parameters must be provided for successful test execution:

Credential/Configuration Settings

Entered with the specific test.

Test Parameters

Word 80% / HTML 80%

Field

Description

Test Name

Enter/modify the name of the test.

Interval

Use the drop-down menu to specify the interval at which Traverse executes the test.

Thresholds (warn/critical)

Enter/modify the threshold levels that cause the test to change to (a state of) Warning or Critical, respectively.

Action Profile

Use the drop-down menu to select an action profile for the test. See Administrator Configured Action Profiles and Thresholds for more information.

Password

Enter your SQL password

Query

Enter/modify the SQL query. For example:

select count(*) from table_name;

Username

Enter your SQL username.

JDBC Driver

Enter/modify the name of the JDBC driver (required to communicate with the database). For example, for a MySQL database, the name of the driver is org.gjt.mm.mysql.Driver.

Port

Enter the port use to access the database. The port number varies depending on the database to which you are connecting.

Database

Enter the name of the database.

As test value rises, severity:

(RPC_Ping, DHCP test only)

Use the drop-down menu to specify the relationship between test value and severity:

  • Auto: If you select this option, Traverse sets this option based on the Warning and Critical thresholds for this test. If the Critical threshold is higher, as test value rises, severity ascends. If the Warning threshold is higher, as test value rises, severity descends.
  • Ascends: As the value of the test result rises, severity rises.
  • Descends: As the value of the test result rises, severity falls.
  • Discrete: Specify a list of integers or ranges of numbers using the syntax: 1,3,5,10-25. Specify different values for warning and critical. Any returned value that does not match a value in either list means the device is OK.
  • Bidirectional: You can set a "range" of numbers for each threshold and if the value crosses either of these two boundaries of the range, it will set the severity to Warning or Critical