<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>I have a query that says it returns 0.0000 and have a warning value of 2:6 and critical value of 7 and am getting a warning.</div><div><br></div><div>This is from the debug file:</div><div><br></div><div><div>[1361472169.305131] [2048.1] [pid=2302] **** BEGIN MACRO PROCESSING ***********</div><div>[1361472169.305133] [2048.1] [pid=2302] Processing: '$USER1$/check_mysql_query --hostname=$ARG1$ --port</div><div>=$ARG2$ --database=$ARG3$ --username=$ARG4$ --password=$ARG5$ --warning=$ARG6$ --critical=$ARG7$ --quer</div><div>y=$ARG8$'</div><div>[1361472169.305154] [2048.1] [pid=2302] Done. Final output: '/export/nagios/libexec/check_mysql_quer</div><div>y --hostname=sd-mysql --port=3308 --database=it_administration --username=ituser --password=########## -</div><div>-warning=2:6 --critical=7 --query="select format(datediff(current_timestamp,UPDATE_TIME),0) from inform</div><div>ation_schema.tables where TABLE_SCHEMA = 'it_administration' and TABLE_NAME = 'SD_AD_USERS'"'</div><div>[1361472169.305157] [2048.1] [pid=2302] **** END MACRO PROCESSING *************</div></div><div><br></div><div>This is from the status:</div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(244, 242, 242); display: inline !important; float: none; font-family: arial, verdana, serif; ">QUERY WARNING: 'select format(datediff(current_timestamp,UPDATE_TIME),0) from information_schema.tables where TABLE_SCHEMA = 'it_administration' and TABLE_NAME = 'SD_AD_USERS'' returned 0.000000</span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(244, 242, 242); display: inline !important; float: none; font-family: arial, verdana, serif; "><br></span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: rgb(241, 238, 238); font-family: arial, verdana, serif; ">What am I doing wrong?</span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: rgb(241, 238, 238); font-family: arial, verdana, serif; "><br></span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: rgb(241, 238, 238); font-family: arial, verdana, serif; "><br></span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: rgb(237, 233, 233); font-family: arial, verdana, serif; ">Thanks,</span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: rgb(237, 233, 233); font-family: arial, verdana, serif; "><br></span></div><div><span style="color: rgb(0, 0, 0); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: rgb(232, 227, 227); font-family: arial, verdana, serif; ">Ken</span></div><div><br></div></body></html>