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 ---- About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." ...

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 About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services . Visit EmmanuelTsouris.com for his latest projects. As an Amazon Associate, I earn from qualifying purchases at no cost to you.