Reporting on MIA machines
i am having issues with users shutting their computer on the weekend, i am trying to find a way to indetify them on the weekend then on monday create a job to push update to those pcs. do you guys have a sql report you mind sharing.
Community Chosen Answer
This is a sql report I set up a while back. It has worked great for me.
SELECT MACHINE.NAME AS SYSTEM_NAME,IP,MAC,SYSTEM_DESCRIPTION, MACHINE.USER_NAME,OS_NAME,OS_ARCH FROM MACHINE WHERE(DATEDIFF(now(),MACHINE.LAST_SYNC) > 10) order by LAST_SYNC
You simply adjust the number in this section "> 10)" to be the number of days since the last sync that are required before it gets added to the report. So in this case the report will only show computers that haven't synced for 10 days. Hope that helps!