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!).