Yes I am sure
the query is
"DECLARE @Start DATETIME DECLARE @End DATETIME SET @Start = CONVERT(datetime, CONVERT(varchar, GETDATE(), 1)) SET @End = DATEADD(Day, 1, @Start) SELECT DATEDIFF(minute, MAX(a.audit_time), GETDATE()) mins FROM ts_audit a (nolock) WHERE a.server_address = N'IP_ADDRESS' AND a.audit_time BETWEEN @Start AND @End AND a.action = 'TSpaymentsInterface::sale' "
Basically an entry is set in a table which gives a value in minutes. If we run this query - it actually comes back with the right value in nagios .. but nagios is only alerting on the first digit. So 2 = 2, 6 = 6 14 = 1 15 = 1 and 5789347589 = 5
Looks like its matching the first text string and stopping there.
Hope this makes sense.