This monitor lets you check that certain conditions exists in a Microsoft SQL or MySQL 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, 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 MyIpswitch portal.
Important: To use the SQL Query Monitor to monitor a MySQL database, you must first download and install the MySQL .NET connector. Because of compatibility issues with later versions, only MySQL version 5.2.5 .NET connector is supported. This connector is located on the WhatsUp Gold website. This link downloads the mysql-connector-net-5.2.5.zip file
. Once downloaded, 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 screen, select Typical and click Install. The MySQL .NET connector is installed at the following location: C:\Program Files\MySQL\MySQL Connector Net 5.2.5\.
After the .NET connector has been installed, restart WhatsUp Gold.
Note: The SQL Query monitor does not support Windows authentication. Make sure that ADO credentials are set up in the Credentials Library for the database for which you want to query. The Credentials system stores ADO database credentials 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 or edit a SQL Query monitor:
Note: MySQL database is supported and listed as a Server Type option if the MySQL 5.2 or later .NET connector is installed. You can download the connector on the MySQL Connectors Download site.
Note: The ServerName\Instance format is only required for SQL Server. MySQL only requires the ServerName.
Important: Ensure that you include the full database name in your query. For query help, click Build. The SQL Query Builder assists in developing proper query syntax.
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 illustrate the monitor you have configured.
After configuring an active monitor in the Active Monitor Library, add the monitor to devices.