Harshit Pandey
Well-Known Member
- Messages
- 300
- Solutions
- 8
- Reaction score
- 9
- Points
- 18
Anyone has handy wql query to create device collection for server 2025 (latest version).
Forums on Intune, SCCM, and Windows 11
Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!
PENDING WQL query for server 2025
- Thread starter Harshit Pandey
- Start date
- Replies 3
- Views 119
OP
Harshit Pandey
Well-Known Member
- Messages
- 300
- Solutions
- 8
- Reaction score
- 9
- Points
- 18
- Thread Starter
- #2
Tried the below query but no results.
Code:
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"
- Messages
- 5,059
- Solutions
- 147
- Reaction score
- 983
- Points
- 413
That query should work, you can try replacing the build number with exact one (26100.32230) and see if that works?
OP
Harshit Pandey
Well-Known Member
- Messages
- 300
- Solutions
- 8
- Reaction score
- 9
- Points
- 18
- Thread Starter
- #4
What if i have multiple build numbers (minor numbers)? Should i use an operator such as OR?