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

Comments

Please log in to comment

Community Chosen Answer

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!

Answered 06/19/2012 by: Ben M
Ninth Degree Black Belt

Please log in to comment

Answers

0

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

Answered 06/19/2012 by: bkelly
Red Belt

  • i am using KACE
  • Okay, I've updated the tags on your post is clear to those that might offer a solution to your question.
Please log in to comment
This content is currently hidden from public view.
Reason: Removed by user request
For more information, visit our FAQ's.

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

Answered 06/21/2012 by: jverbosk
Red Belt

  • 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.
Please log in to comment
Answer this question or Comment on this question for clarity