PENDING SCCM device collection to find computers that need reboot

[SimonTaylor]

Hi,

I need to create a Device Collection to show which servers require a reboot.

I am using a limiting device collection of all my servers 500+

And using the query below

SELECT DISTINCT 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_UpdateComplianceStatus
ON SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid
WHERE SMS_UpdateComplianceStatus.LastEnforcementMessageID = 9

But nothing is showing? Any suggestions?

 

[Prajwal Desai]

Alternate method - http://blog.coretech.dk/kea/dealing-with-reboot-pending-clients-in-configuration-manager-2012/

 

[SimonTaylor]

Thank you I'll have a look at that

 

[Prajwal Desai]

Let me know if you need any further help on this before I mark it solved.

 

[abdulrehmanbinaltaf]

whats next after this ? how we can see the pending server restart required list ?

 

[Edy]

then you go to the device collection, right click and show members.

 

[Garth]

The Free Enhansoft giveaway will tell you this if you are using CMCB.
https://www.enhansoft.com/blog/soft...shboard-set-special-microsoft-ignite-giveaway
Keep in mind free giveaway will be changing on Oct. 1 (Eastern time zone)
https://giveaway.enhansoft.com/