SOLVED SCCM Query statement to add devices automatically

[syed sameer]

Hi Prajwal

I tried to add Query statement to add Client machines automatically to my specified device collection

I use your Query from your blog but nothing has changed after I apply the setting I removed sccm client

from client and tested but device collection not updates , see the screen shot this is i'm using manual adding

but I don't want to use it I want always Windows 7 32 bit machines should come to device collection
without I add, how to do ? kindly advise or sent me Query I tried the one which you posted on your blog but
could not success

 

[Prajwal Desai]

So you basically are looking to create a device collection of All windows 7 computer with 32 bit OS ?.

 

[syed sameer]

yes right, and all windows 7 32 bit PC's should automatically come to device collection, I should not need to add manually

 

[Prajwal Desai]

I suppose you are using the correct query, is it collection 64 bit OS as well ?.

 

[syed sameer]

No I have different collection for 64 bit

But now clients adding automatically to the collection

It's resolved

Thanks

 

[Prajwal Desai]

okay so just to cross check you used the same query that I posted on my website ?. Can you post the query here ? It will help other people as well.

 

[syed sameer]

hi prajwal

here is the Query statement for Win 7 machines , once I added the below Query all clients added automatically

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 "%Workstation 6.1%"

 

[Prajwal Desai]

Thank you. Marking this thread as Solved.