In this article, we will create a dynamic device collection for Windows Server 2025 in SCCM. Using the query below, administrators can automatically group Windows Server 2025 systems and simplify patch management, software deployments, compliance reporting, and administrative tasks across the environment.
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.Caption like "Microsoft Windows Server 2025%"
