SOLVED Windows 10 collection SCCM query

[syed sameer]

Hi Prajwal


how are you doing ?

is there any Query for windows 10 Client machines ? I use below Query to add Automatic Win 10 clients to Device collection , is it right one ?

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 10%"

 

[Prajwal Desai]

Its here - http://prajwaldesai.com/community/threads/sccm-query-for-windows-10-collection.287/

 

[syed sameer]

Dear

is that Automatic Query and which bit it will take under this query 32 or 64?

 

[Prajwal Desai]

No the link points to queries that will collect windows 10 pro and windows 1o enterprise computers. What exactly are you looking for ?.

 

[syed sameer]

I want to add all windows 10 x86 bit computers automatically to device collection

 

[syed sameer]

Hi Prajwal

I still waiting for your reply for Win 10 Query for 32 and 64 bit

what I need exactly is I created Windows 10 device collection now I want whatever new Windows 10 will add to my domain network it should automatically add to win10 device collection

I think you got my point now

 

[Prajwal Desai]

@syed sameer - I haven't tested the below queries, you could try and let me know if they work.

For 32 bit Windows 10 -

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion = “%Microsoft Windows NT Workstation 10%” and SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC"

For 64 bit Windows 10 -

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_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion = “%Microsoft Windows NT Workstation 10%” and SMS_G_System_SYSTEM.SystemType = "X64-based PC"

 

[syed sameer]

Hi Prajwal

non of the above Query working see the attachment I cannot save the query

 

[Prajwal Desai]

@syed sameer - Sorry for posting the incorrect query. Try this one for 64 bit windows 10 and let me know if it works

select *  from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 10" and SMS_G_System_SYSTEM.SystemType = "X64-based PC"

 

[syed sameer]

thanks above query taken without error

but is this automatic query right ? I mean Windows 10 client will add automatically using this Query

 

[syed sameer]

Hi Prajwal

I added above query after I added it 2 PC removed from Windows 10 Device collection then I add below Build query those pc came back in device collection, issue still occurring

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

 

[Prajwal Desai]

depends on what query you have used. I see you are grouping the devices using the build number.

 

[syed sameer]

Thanks for info prajwal

 

[Prajwal Desai]

Marking this thread as Solved.