This monitor lets you check that certain conditions exist in a Microsoft SQL, MySQL, or ORACLE database, based on a database query. You can define the criteria you want to exist in the database and as long as the specified conditions are present, the SQL Query monitor is in an up state. If the database data changes outside the boundaries of the query criteria, the monitor triggers to a down state.
After the monitor is configured on this dialog, you must assign the monitor to a device through the Device Properties > Active Monitors dialog.
Note: This feature is only available in WhatsUp Gold Premium Edition. To update your license, visit the WhatsUp Customer Portal.
Important: To use the SQL Query monitor to monitor a MySQL database, you must first download and install the MySQL .NET Connector on the WhatsUp Gold machine. Note that only MySQL version 5.2.5 .NET Connector is supported due to compatibility issues. The connector is located on the WhatsUp Gold website (http://www.whatsupgold.com/MySQL525Connector). This link downloads the mysql-connector-net-5.2.5.zip
file. After the file downloads, extract the MySQL.Data.msi
and run the MySQL Connector setup utility by double-clicking on the MySQL.Data.msi icon. On the Choose Setup Type dialog, select Typical, then click Install. The MySQL .NET Connector is installed in the following location: C:\Program Files\MySQL\MySQL Connector Net 5.2.5\
. After the .NET Connector has been installed, restart the WhatsUp Gold machine.
Note: The SQL Query monitor supports Windows and ADO authentication. Make sure that credentials are setup in the Credentials Library for the database for which you want to query. The credentials system stores Windows and ADO database credential information in your WhatsUp Gold database to be used when a database connection is required. For more information, see Using credentials.
Note: When connecting to a remote SQL instance, WhatsUp Gold only supports the TCP/IP network library.
To add a new SQL Query active monitor:
Server Properties
Note: MySQL database is supported and listed as a server type option only if the MySQL 5.2.5 Connector is installed.
Note: The connection timeout setting configured by the user is used for polling only; the query builder does not use it. Instead, the query builder assumes a default of 15 seconds for the connection timeout.
ServerName\Instance
format for Microsoft SQL Server (for example, WUGServer\SQLEXPRESS), ServerName
for MySQL (for example, WUGServer), or ServerName/ServiceName
for Oracle (for example, WUGServer/Oracle).Note: When using an Oracle server type, the SQL query monitor does not make use of the tsnnames.ora file on the client (i.e. WhatsUp Gold system).
Important: Make sure that you include the full database name in your query. For query help, click Build. The SQL Query Builder will assist you in developing proper query syntax.
Important: The SQL query you enter must return a single numeric value. Specifically, a single record that has just one column. If the query returns more than one record, the monitor will fail to store the data. If the query returns a single record but there are multiple columns in the record returned, then the monitor will pick the first column as the value to store and this first column has to be numeric, otherwise the monitor will fail to store the data.
Monitor is up if
Important: All database rows must match the criteria settings in the Monitor is up if section for the monitor to be considered up. If multiple threshold criteria is used in the Content of each retrieved row matches the following criteria, all thresholds must match the criteria in each row.
Enter a numeric value for number of rows in the box to the right of the conditions list.
As you specify the desired monitor criteria settings, this description updates to verbally illustrate the monitor you have configured.
To edit an existing SQL Query active monitor:
Server Properties
Note: MySQL database is supported and listed as a server type option only if the MySQL 5.2.5 Connector is installed.
Note: The connection timeout setting configured by the user is used for polling only; the query builder does not use it. Instead, the query builder assumes a default of 15 seconds for the connection timeout.
ServerName\Instance
format for Microsoft SQL Server (for example, WUGServer\SQLEXPRESS), ServerName
for MySQL (for example, WUGServer), or ServerName/ServiceName
for Oracle (for example, WUGServer/Oracle).Note: When using an Oracle server type, the SQL query monitor does not make use of the tsnnames.ora file on the client (i.e. WhatsUp Gold system).
Important: Make sure that you include the full database name in your query. For query help, click Build. The SQL Query Builder will assist you in developing proper query syntax.
Important: The SQL query you enter must return a single numeric value. Specifically, a single record that has just one column. If the query returns more than one record, the monitor will fail to store the data. If the query returns a single record but there are multiple columns in the record returned, then the monitor will pick the first column as the value to store and this first column has to be numeric, otherwise the monitor will fail to store the data.
Monitor is up if
Important: All database rows must match the criteria settings in the Monitor is up if section for the monitor to be considered up. If multiple threshold criteria is used in the Content of each retrieved row matches the following criteria, all thresholds must match the criteria in each row.
Enter a numeric value for number of rows in the box to the right of the conditions list.
As you specify the desired monitor criteria settings, this description updates to verbally illustrate the monitor you have configured.