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
