Forums on Intune, SCCM, and Windows 11

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

PENDING SCCM device collection to find computers that need reboot

SimonTaylor

New Member
Messages
4
Reaction score
0
Points
1
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?
 

Forum statistics

Threads
7,026
Messages
27,498
Members
17,677
Latest member
Nairolf

Trending content

Back
Top