Forum Discussion

wfry24's avatar
wfry24
Copper Contributor
Feb 06, 2026

New MECM Build, Device Collections not showing devices

I just built a new MECM server and updated it to version 2509. I imported an older Device Collection script to make collections. The Windows Server 2012/2012R2 did find the 4 servers that I have b...
Device Group
mertefekanlikilic's avatar
mertefekanlikilic
MCT
Feb 13, 2026

Hi wfry24​ 

The problem was the attribute used in the query.

SMS_R_System.OperatingSystem is not consistent and doesn’t always contain a reliable “Server” value. Switching to OperatingSystemNameandVersion resolves the issue.

This query correctly adds Windows Server 2012 R2 and also covers all newer Server versions:

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
where SMS_R_System.OperatingSystemNameandVersion like "%Server%"

After changing the query, the servers appeared in the collection as expected.

Hope it helps.