Reporting on MIA machines
hello guys-
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.
thanks
alex
Answers (3)
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!
What systems management solution are you utilizing? KACE, Microsoft, Altirs?
Comments:
-
i am using KACE - brighstarcuit 12 years ago
-
Okay, I've updated the tags on your post is clear to those that might offer a solution to your question. - bkelly 12 years ago
If you are just trying to handle patching these machines, you could use the "Run on next connection if offline" option in the patch schedule. I use this for all of my client machine patch schedules (with a 15 minute delay) and it has worked extremely well (as evidenced by the patching status reports I've set up).
John
Comments:
-
thanks jverbosk, this solution will not work for me i need to indentify those machines first then update as soon as i get a connection. - brighstarcuit 12 years ago
