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 but for 2019, 2022 and 2025, nothing is showing.

Here are some queries that I have tried:

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Version = "10.0.20348"

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%Server 10%" and SMS_G_System_OPERATING_SYSTEM.BuildNumber = "20348"

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber = "20348"

I even tried one using the OS Name.

The limiting Collection used is Servers | All which shows 97. I also changed it back to All Systems, but to no avail.

All the boundries and boundry groups are set.

 

 

Device Group

1 Reply

  • 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.