DotVBS | Windows Systems Management

Collections seem to be on our mind, all the time, so here's another to help reboot those pesky non- rebooters . This WQL will give you all your reboot pending computers, so you can send them a reboot package. Ha! Take that, non- rebooters ! ----Begin WQL ---- 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" ----End WQL ----

A couple of common SMS Audit Status Message IDs. 30103 Session Release 30007 Modify an Advertisement 30102 Create a Session 30010 Modify a DP 30104 Update a collection 30034 Modify Discovery Agent 30000 Create a Package