SOLVED SCCM device collection query for windows 8.1

[Dineshyadav]

Hi, I have grouped Windows 7 computers into a collection using a query. Can anyone tell me SCCM device collection query for windows 8.1 ?.

 

[Prajwal Desai]

Hi Dinesh,

You can use the following query to create a collection of Windows 8.1 computers –
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 “Microsoft Windows NT Workstation 6.3%“

Try this and let me know if it doesn't work.

 

[Dineshyadav]

Thanks Prajwal. I will try the query and will let you know if it doesn't work.

 

[Dineshyadav]

Hi, the collection query worked fine. Thanks.