Hi all, I'm trying to make a new collection with a query for "not in a collection X & not in X's subcollections" and having a tough time at it. I typically use SubSelected Values - System Resource - Resource ID - is not in - "select ResourceID from SMS_CM_RES_COLL_DOF0002C" I believe this is currently querying the main collection (empty), as it is right now. Does anyone know how to do this? The Internet + help files don't seem to be producing much help (or I'm lacking in search skills). Thanks for any help you can give! *Mike

Thanks for the help. By main collection I meant the collection above which the sub-collections exist. My problem is that the collection I need to make (lets call it NEW) needs to exclude a collection (let's call it PITA) for which new sub collections get made periodically. So I'd like NEW to reflect changes to PITA and it's sub collections. The problem I have is that I would need to change the query statement in NEW every time I make a change to the sub collections of PITA. Thanks for the information Matt, it seems there is no way around this. And Trevor I will keep your method to test with, thank you.

It's difficult to tell exactly what you want to do, but I think this will help for at least part of the solution: http://myitforum.com/cs2/blogs/jsandys/archive/2009/08/14/roll-up-collections.aspx.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys

Thanks Jason, that was pretty much exactly what I was looking for. That let me create a single collection filled with the subcollections of another. I could then create a collection of things that DON'T include that collection, which is what I wanted. Overall --site1 --site2 --site3 new collection --(all comps not in 1, 2, 3, or any other future collections created under "overall")

Thank you Jannes, you definitely put me on the right track.