While running a report, what is the value for last system restart?
I have been using the report wizard to run a report on users who have not restarted in over 7 days. When I choose the criteria "Last system reboot > X" is the X in hours, days, minutes, etc? I keep getting no results shown then i try to view it.
i only want to see users who have not rebooted in over 7 days, no one else. Any help would be greatly appreciated!
SELECT NAME, USER_LOGGED, LAST_REBOOT FROM MACHINE M WHERE LAST_REBOOT < DATE_SUB(NOW(), INTERVAL 7 DAY) ORDER BY M.NAME