Report to show when a machine is connected and the last reboot is greater than x days?
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
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
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
