PENDING WQL query for server 2025

[Harshit Pandey]

Anyone has handy wql query to create device collection for server 2025 (latest version).

 

[Harshit Pandey]

Tried the below query but no results.

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 = "26100"

 

[Prajwal Desai]

That query should work, you can try replacing the build number with exact one (26100.32230) and see if that works?

 

[Harshit Pandey]

What if i have multiple build numbers (minor numbers)? Should i use an operator such as OR?

 

[Prajwal Desai]

Hi, any update on this issue?