/build/static/layout/Breadcrumb_cap_w.png

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

 


0 Comments   [ + ] Show comments

Answers (3)

Posted by: Ben M 11 years ago
9th Degree Black Belt
4

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!

Posted by: bkelly 11 years ago
Red Belt
0

What systems management solution are you utilizing? KACE, Microsoft, Altirs?


Comments:
  • i am using KACE - brighstarcuit 11 years ago
  • Okay, I've updated the tags on your post is clear to those that might offer a solution to your question. - bkelly 11 years ago
Posted by: jverbosk 11 years ago
Red Belt
0

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 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ