HiI have been looking for a way to set up a collection that when ever a server is put onto our network it goes into a collection for unassigned servers, the reason we do this is that with our business alot of our servers have to be patched manually and alot have to be set to patch and reboot automatically. Unfortunately we have servers and workstations that are added and destroyed daily and that makes my life very difficult trying to keep up with them all. The servers that have to be patched manually also do not have anything in common with each other, otherwise that would make things easier, so I would have to rely on SCCM to find servers that are not already in a specified collection so they would automatically go to an unassigned collection, that way we could chose what collection to put them in, then once in one of the many specified collections they would then leave the unassigned collection, does anyone have any ideas on how to do this? This would be a huge help, Thanks!!!

Hi,You can use the example on this post from Jannes - http://www.jannesalink.com/blog1.php/2009/12/07/dynamically-fill-a-collection-with-membeKent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

Thanks for the speedy answer, but I am still running into some syntax errors when trying to apply this to our configuration, I changed the collection to the right name but I still don't know where I am going wrong. Is there way that I can get an example not in query language? Sorry for the hand holding on this one, I am still pretty new on writing these queries. Thanks!!!

Hi,You need the Collection ID not the name. Check the collection properties for the right ID. Also this query only works in ConfigMgr not in SQL.To test it in SQL you need to replace SMS_ with v_Follow me through my blog and Twitter!

Here's one I use for the exact same thing: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.Client = 1) and (ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_P0100058)) and (ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_P0100059)) and (ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_P0100057)) and (ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_P010005C)) and (ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_P010005A)) and (ResourceID not in (Select ResourceID from SMS_CM_RES_COLL_P010005B)) John Marcum | http://www.TrueSec.com/en/Training.htm | http://myitforum.com/cs2/blogs/jmarcum

That is fantasic, this will make my job so much easier, I will now be able to keep track of all the servers and workstations that are added and destroyed off of our network, and we won't have to worry that we missed servers that needed patching, thank you so much!!!!

I am still coming up with uses for this query, it has been more useful than any other query I have found in a long while. The most current use I have for it was seperating all the "ad sites" unfortunately we had a bunch of servers that were showing up as <null> in the properties, so of course I couldn't do it that way, so I created a collection for all the ad sites and one that has all the servers. After that I used that same query assigned on the collection that has all the servers and watched my list shrink to just the ones where the ad site was null. This rocks, I hope you guys can use this for alot of other things, I know I do.Thanks again.