The SQL Query monitor uses Windows or ADO authentication to determine if specific conditions exist in a Microsoft SQL, MySQL, or ORACLE database by querying the database.
Important: To monitor a MySQL database, download and install the MySQL .NET Connector on the WhatsUp Gold machine. Please note, the latest version of WhatsUp Gold only supports MySQL .NET Connector version 8.0.21 due to potential compatibility issues. If you are using application monitoring features and/or SQL Query active or performance monitors, you must download and upgrade your connector from version 5.2.5 to 8.0.21. The MySQL .NET Connector can be downloaded here: https://downloads.mysql.com/archives/c-net/.
Note: When connecting to a remote SQL instance, WhatsUp Gold only supports the TCP/IP network library.
Provide a unique name and description for the monitor, then configure the following:
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 fails 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.
Click Verify to test if the entered database query is valid.