SCCM collection query script

[gatorcb]

We are trying to migrate from 2007 to 2012. Our collections won't migrate because we are using queries that reference a 3rd party product in 2007 that's not installed in 2012. Here's what we have

 

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.SystemGroupName = "DOM\\APP-AdobeApproval" or SMS_R_System.ESDmemberof = "DOM\\APP-AdobeApproval"

 

Since we have over 1000 collections and are still using ESD, we'd like to have a script return the above data to a file. Then we break that file up into smaller sections (by hand), then we have a script take that new smaller subset file as input and remove the "or SMS_R_System.ESDmemberof = "DOM\\APP-AdobeApproval"" part (basically the esd piece). Then we'll create a migration job in sccm 2012 and migrate those apps. Then we need another script to read the smaller subset file again and put the query back as listed above.

 

Any help would be much appreciated. I don't do much with vbscript

[GarthMJ]

Have you talked to the team at Flexera to see how they suggest you handle this issue? They are the best people to talk to about this.