MySQL test for Nagios

MySQL test for Nagios

We're running ServiceDesk Plus MSP on CentOS 5.5.

I want to monitor the number of unassigned requests with a MySQL query.  All I need the check to return is a number, as it will feed into our Nagios system, so we can trigger alerts for our engineers. 

All the checks I've found for this on the forums are massive, and return too much information (and my MySQL knowledge isn't enough to reduce the query down!).

Hope someone can help!










                New to ADSelfService Plus?