/build/static/layout/Breadcrumb_cap_w.png

Is there a way to setup schedule to reboot machines which are pending reboot after patching on the K1000?

For patching we cannot use force reboot due to the multiple shifts we have.  I push patches but I want to schedule reboots for like 1 or 2 in the morning.  Any way to create some sort of smart label and schedule to accomplish this?

 

I'm working on getting my networking team to setup Wake On LAN so I can change my patching schedules but until that is done I need another way to make sure patches are getting done and machines are being rebooted.


2 Comments   [ + ] Show comments
  • As a stop gap you could target the same label or group of machines you are using for patching with the built in script called Shutdown a Windows System but modify the command from the shutdown -s to a shutdown -r - Timi 10 years ago
    • I only want ones that need reboots to get rebooted. Not just a wholesale reboot the environment type script. I also don't want the script to reboot a machine if it misses the window. I've noticed if I set a schedule and the machine is off when the machine turns on it sees the schedule is in the past and reboots again. That is a real PITA and I don't want that to happen. - petelanglois 10 years ago
      • Do you have the box selected that states Run on next connection if offline?
        You would most likely need to do some custom sql work to get the label to identify the machines that are pending reboot. There is a report in the patching category that shows computers pending reboot you could use some of that code. - Timi 10 years ago
      • I make sure that is not checked. I guess I'm just going to wait until the network team gets WOL setup. My issues will all go away as I will just power on all the desktops, patch and then shut them all down. - petelanglois 10 years ago
  • I have created this patch label via copy/paste and it seem to be catching every machine. - AGB123 8 years ago

Answers (1)

Answer Summary:
Create a smart label with this SQL query and have a reboot script run against that label on the same day(s) as you run patching but at 2AM...make sure you set a delay on the shutdown -r (Restart) command as per this Solution Article: http://www.kace.com/support/resources/kb/solutiondetail?sol=SOL111291 select NAME, IP, LAST_SYNC, UPTIME from MACHINE join KBSYS.KONDUCTOR_TASK KT on KT.KUID = MACHINE.KUID and KT.TYPE like 'patch%' and KT.PHASE ='reboot pending' order by MACHINE.NAME
Posted by: easterdaymatt 10 years ago
7th Degree Black Belt
2

Create a smart label with this SQL query and have a reboot script run against that label on the same day(s) as you run patching but at 2AM...make sure you set a delay on the shutdown -r (Restart) command as per this Solution Article: http://www.kace.com/support/resources/kb/solutiondetail?sol=SOL111291

select NAME, IP, LAST_SYNC, UPTIME

from MACHINE

join KBSYS.KONDUCTOR_TASK KT on KT.KUID = MACHINE.KUID and KT.TYPE like 'patch%' and KT.PHASE ='reboot pending'

order by MACHINE.NAME

Comments:
  • Thanks! - petelanglois 10 years ago
  • I am unable to locate the option to Create a smart label with this SQL query? Please help! - bnerison 9 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