This blog is to create a device collection to know which machines in your enterprise need rebooting after software updates.
Add a new query rule and specify the name for the query. Next, on the Query Rule window, click Edit Query Statement and past the below query in the Query Language box. This query will find all the computers with pending restarts:
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 joinsms_combineddeviceresources on sms_combineddeviceresources.resourceid =sms_r_system.resourceid wheresms_combineddeviceresources.clientstate != 0
Copy the query statement provided in this document and open Edit Query Statement
Paste the query statement provided in this document and select OK
After selecting the OK button for both the Query Statement Properties and Query Rules Properties boxes. Select Next
Subscribe for helpful tips and information from BCS Enterprise iT.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.