SQL Query (Active)

The SQL Query monitor uses WMI or ADO authentication to determine if specific conditions exist in a Microsoft SQL, MySQL, or ORACLE database by querying the database. If the configured conditions are present, the monitor is Up. If changes made to the database since the last query cause data to no longer fall within the defined criteria, the monitor is Down.

Important: To monitor a MySQL database, download and install the MySQL .NET Connector on the WhatsUp Gold machine. Please note, only MySQL .NET Connector version 5.2.5 is supported due to potential compatibility issues. The MySQL .NET Connector can be downloaded here.

If you would like to begin monitoring MySQL 5.6/5.7 using this version of WhatsUp Gold, you’ll first need to download the v5.2.5 connector in .zip archive format here. After accessing the MySQL Product Archives URL, select 5.2.5 as the Product Version and .NET & Mono as the Operating System from the applicable drop-down menus, then click Download. Extract the MySql.data.dll file from the downloaded .zip package, then copy it into the following two locations inside the WhatsUp Gold installation folder:
C:\Program Files (x86)\Ipswitch\WhatsUp\
C:\Program Files (x86)\Ipswitch\WhatsUp\html\NM.UI\bin\extensions\WUG\
Please note, the file paths displayed here represent the default locations used by the installation program. If you have WhatsUp Gold installed in a different location, copy the .dll file into the corresponding folders on your server.

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:

Click Build to launch the SQL Query Builder for assistance with developing proper query syntax. Only SELECT queries are allowed.

Important: WhatsUp Gold Active monitors do not store results data. If you want to track query results, use the SQL Query Performance Monitor.

Click Verify to test if the entered database query is valid.

Number of rows returned is. Select this option to determine the success or failure of the monitor scan based on rows returned by the SQL query. All database rows must match the criteria settings for the monitor to be considered Up.

Content of each retrieved row matches the following criteria. Select this option to determine the success or failure of the monitor scan based on criteria each database row must match. If multiple threshold criteria are used, all thresholds must match the criteria in each row for the monitor to be considered Up.

Click Add, Edit, and Delete as needed to create, modify, and remove database column values and conditions, respectively.

See Also

Active Monitors

Active Script (Active)

APC UPS (Active)

BGP Peer Status

Cloud Resource Monitor

DNS

Email

Exchange 2003

Exchange

Fan

File Content

File Properties

Folder

FTP

HTTP Content

JMX (Active)

Meraki Device Status Active Monitor

Network Statistics

Service

Ping Interarrival Jitter

Ping

Power Supply

PowerShell

Printer

Process

SMI-S

SNMP Extended

SNMP (Active)

SQL Server

SSH (Active)

SSL Certificate

Storage Controller Health monitor

Storage File System

Storage Disk Drives

Storage LUN

Storage Pool

TCPIP

Telnet

Temperature

VoIP

WAP Radio

WMI Formatted

WMI

Set Polling Properties

Apply Action to Monitor

Using Action Policies

Implicit Action Policy