HI,

I have to create a IP Subnet based Device Collection , are we have to install the ccm clients on all machines first to create the IP subnet based Device Collection??

Can you please share the step by step docs to create the IP Subnet based device collection in SCCM 2012 R2?

Yes. You will have to install the CCM Client first and then you can create the IP Subnet based device collection.

-RG

Is for all Query based device Collection ccm agent required? can you please refer some docs regarding.

Without SCCM Client you can only create query based collections based on the Discovery Information.

I don't have any documentation on it as such for now, let me see if I can find something for you.

-RG

Hello, As has already been mentioned this will require the SCCM client to be installed on the workstations to pick up the IP address and may require a Hardware Inventory cycle to have been ran (not 100% certain of the HW Inv requirement, give it a try without and see!).

• Create the collection as you would normally.
• right click the collection and select properties. Click into the membership rules tab
• select add rule > query rule
• Type a name "IP Subnets" and then click "Edit query statement"
• Click "Show Query language at the bottom and enter the below query making changes to the IP address.

    select *  from  SMS_R_System where SMS_R_System.IPSubnets like "172.16.5%"

• Update the collection membership. Job done.

I am not sure how whether this information will remain bang up to date e.g. if a machine moves subnets it may not instantaneously update the data in the database regarding IP subnets.

• Edited by d4rkcell 18 hours 1 minutes ago

The following link will help you understanding query based collections better. The bottom line is that you can create collections based on the information in the Database. Database is fed with information once at discovery and then during the Client Inventory collection. So in essence, without the Sccm client the scope of creating Query based collections is very limited and is confined to the Discovery data.

http://www.hayesjupe.com/sccm-collections-the-basics/

-RG

Please try this once you have your clients ready. You need to create a query based collection.

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.IPSubnets = "192.168.X.X" ORDER BY SMS_R_System.IPSubnets

Thanks

Hi,

Different discovery method focus on different information, check this article:

https://technet.microsoft.com/en-us/library/bb632733.aspx

And Jason has a good blog on heartbeat discovery:

http://blogs.catapultsystems.com/jsandys/archive/2011/04/29/what%E2%80%99s-in-a-heartbeat.aspx