Advertisement
Guest User

Untitled

a guest
May 19th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.09 KB | None | 0 0
  1. 12:04|0|0|DB Error: unknown error QUERY :
  2. SELECT \* FROM log
  3. WHERE ctime > '1271027052' AND ctime <= '1271329452'
  4.     AND (
  5.         (msg_type IN ('2', '3')  AND status IN ('NULL','UP','DOWN','UNREACHABLE','OK','WARNING','CRITICAL') )  
  6.     OR  (msg_type IN ('0', '1')  AND status IN ('NULL','UP','DOWN','UNREACHABLE','OK',','WARNING','CRITICAL')  AND type = 'HARD' )  
  7.     OR  (msg_type IN ('4', '5', '6', '7', '8', '9') AND status IS NULL) )
  8. AND ((host_name IN ('XXX') AND service_description IS NULL)
  9. OR (host_name = 'Ash' AND service_description
  10.     IN ('CPU Usage Windows','Dameware Mini Remote Control','Dell Hardware General','Dell Hardware Memory Check','Drive C Usage','Drive D Usage','FTP Port Check','McAfee Engine Service Check','McAfee Framework Service Check','McAfee McShield Service Check','McAfee Task Manager','McAfee Validation Trust Protection Service Check','Memory Usage Windows','Microsoft SQL Port Check','Microsoft SQL Server Agent Service','Microsoft SQL Server Service Check','Ping','Uptime Windows','WAR FTP Server','Windows Time')) )
  11. ORDER BY ctime DESC, host_name ASC, service_description ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement