Report to show when a machine is connected and the last reboot is greater than x days?
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.
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