SOLVED Device Collection for Windows Server Datacenter and Standard editions

[Harshit Pandey]

Hi all,

We have a mix of Windows Servers where some of them are datacenter editions and others are standard editions. I am looking to create a separate device collection for Windows server Standard and datacenter server edition. How to do that? I have seen some WQL queries that use OS caption to differentiate between standard and datacenter editions. Can I avoid using the caption and use something that works?

 

[Prajwal Desai]

You will have to use the operating system name / caption in the WQL query to distinguish between the standard and datacenter editions of Windows Server.



So the query will be something like this

Windows Server 2025 Datacenter Edition

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.26100" and SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows Server 2025 Datacenter"

Windows Server 2025 Standard edition

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.26100" and SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows Server 2025 Standard"

 

[Harshit Pandey]

Ok so no other ways to query without using the OS name and caption here?.

 

[Prajwal Desai]

May I ask what is preventing you from using the OS name in the query?

 

[Harshit Pandey]

I feel it's not accurate. But if there is no other way, I will have to use it then.

 

[Prajwal Desai]

That's incorrect. The query that I provided works and I have tested it on the production server. If it doesn't work, you can contact me.