Hello

I have a MYSQL report (see below) that I created using 2 exsisting reports that I have but, cant get the last machine reboot date to show up on the report. Any help or guidenance for this very much appreciated.

Thanks

 

SELECT MACHINE.IP, SC.CLIENT_CONNECTED, MACHINE.NAME AS SYSTEM_NAME, USER_LOGGED FROM MACHINE  LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID 

WHERE SC.CLIENT_CONNECTED LIKE '1'

AND (LAST_REBOOT < DATE_SUB(NOW(),INTERVAL 7 day)) ORDER BY LAST_REBOOT

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

Add LAST_REBOOT.

SELECT MACHINE.IP, SC.CLIENT_CONNECTED, MACHINE.NAME AS SYSTEM_NAME, USER_LOGGED, LAST_REBOOT

FROM MACHINE

LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID

 

WHERE SC.CLIENT_CONNECTED LIKE '1'

 

AND (LAST_REBOOT < DATE_SUB(NOW(),INTERVAL 7 day)) ORDER BY LAST_REBOOT
Answered 09/04/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity