I have been askedd to remove a list of computers provided in a text file from a direct membership collection, normally this would be easy and I would use Collection Injector as it is a great solution which is pretty much foolproof, however for some reason that is totally beyond me and who knows why, I have been told to see if there is a script to perform the same functionality, but why reinvent the wheel.....go figure

so in essence, does anyone know of a script to accomplish this????I can find them for a single computer but not for a list based solution, any help greatly appreciated

r

Hmmm.... probably so but for 2007 I'd use collection injection. :-)

PoSH for 2012

You can do it using powershell+WMI.

Also, if you are looking to remove a llist of machines from a collection. Why don't you try writing a query?

some like...

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 whereSMS_R_System.NetbiosName not in ("null")

here put the list of computers in the not in list..

Also, if you are looking to remove a llist of machines from a collection. Why don't you try writing a query?

some like...

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 whereSMS_R_System.NetbiosName not in ("null")

here put the list of computers in the not in list..

HI,

thanks for the answers, with regards to the SMS query , I did suggest a query based collection that would get the same functionality, but it must be in powershell....dont ask......

HI,

thanks for the answers, with regards to the SMS query , I did suggest a query based collection that would get the same functionality, but it must be in powershell....dont ask