WQL Queries - Collection of computers needed restart after patches

Main Menu > Tools > WQL Queries

Collection of computers needed restart after patches

Create a collection of computers that need a restart after patches

Code

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_PatchStatusEx on SMS_G_System_PatchStatusEx.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PatchStatusEx.LastStateName = "reboot pending"

Documentation

Sometimes after you patch the machine should restart during it's maintanence window. There are always times with the client it told to restart but it never does. This will create a collection of such computers. From here I normally set an advertisment to run the "shutdown -r -f -c Patch restart -t 300" This way the computer restarts during the normal MW. --------------------------------