HI Jason,
understand try these powershell commands: New-CMDeviceCollection -LimitingCollectionName "all systems" -Name x.x.x.x Add-CMDeviceCollectionQueryMembershipRule -CollectionName x.x.x.x -QueryExpression "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"" -RuleName "computers in x.x.x.x" what I would do is export the default gateways from SQL into excel, and then change out the x.x.x.x for the IP address and fill down on the sheet, and copy into notepad, clean up the Tab’s then paste it into powershell ISE and run it hope that helps Cheers Steve From: Jason Wallace Sent: Friday, 11 July 2014 5:33 PM To: [email protected] 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
