Hi there Steve Thanks for that! That is precisely what we DO have and it works really well indeed. I have an engineer sat there however going through a list of several hundred IP subnets and creating this collection. The list that we built was in itself built from a simple DISTINCT selection of default gateways from hardware inventory. I was hoping to go a little further and script the extract from HW inventory and then cycle through this list, creating collections based upon the default gateways Jason From: [email protected] To: [email protected] Subject: Re: [mssms] SCCM collection creation by script Date: Fri, 11 Jul 2014 06:16:35 +0000
Hi Jason, try this: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_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DefaultIPGateway = "x.x.x.x" Just change the x.x.x.x to the default Gateway Address. Cheers Steve From: Jason Wallace Sent: Friday, 11 July 2014 3:50 PM To: [email protected] Hi folks A dumb question for this morning but . . . I am in the midst of a 2007 - 2012 migration. We want to move devices over by IP subnet as there are a large number of branch offices. I wonder whether someone has a magic script that can allow us to read the default gateway from hardware inventory and then create a series of collections on that please? Thanks
