RE: How to combine existing collections to include or exclude...

Tell ya what...let me do some work over here by creating some stuff and I
will see if I can't just send you the collection queries and the query
itself. based on what you want.
It will be either later today or tomorrow, if that is ok. Assuming no one
else answers this better for you.



"George Phillips" wrote:

Wow, you kind of lost me. They didn't make SMS for dumb people like me, did
they? :) Is there a resource or white paper you can point me to that might
demonstrate this step by step?

My collection A already has the 'Limit to Collection' selected because this
is selecting the computers in my remote offices via AD but limits it only to
the Windows 2003 Server collection so that collection A contains only Windows
2003 Servers in my remote offices. I want to be able to use the Direct
Membership to populate collection B so that I can exclude servers at will by
advertising to Collection C which is equal to A minus B.

Thanks,
George

"Matthew Hudson" wrote:

Sorry about that part, you will need to create a query based on a set of data
(asking for only computer name)
then edit the collection and do a query "Sub selected values" you can then
select the query and say "computer name" not it (your created query) limited
to your other collection

This will grab all the computers that are in the limited collected minus the
ones that are already in the query.

I am not sure this made much sense...

Basically you have Collection A, B and you want a new collection that is A-B
= C
C collection is limited to collection A.
Query X is all computers in B
C Collection query is now "Sub selected values" of computer names Where A is
not in Query X

How does that sound?

"George Phillips" wrote:

Thanks, Matthew, for the tip! That will help me add two collections together.
What do you recommend for excluding a collection? Using my earlier example,
suppose I want to create a collection that consists of Collection A minus
Collection B?

Thanks,
George

"Matthew Hudson" wrote:

There are several ways you can do this,
Choice A:

You can create a new collection D and then right click and create a "link to
collection" This will create a duplicate of a selected collection under D,
you can do this for all of them. Then create an advertisment that is posted
to D and include subcollections. This will do all a,c.

Choice B:

Create a new collection D. Copy each of the criterias in to that collection
(without limitations). Then you will have 2 queries (all limited as they
were) but will combine in one collection.

"George Phillips" wrote:

Can someone help me understand what needs to be done in SMS 2003 SP2 to
combine existing collections to effectively create a different collection.
Suppose I have collection A, collection B and collection C. I want to be able
to advertise a package/program to a collection that would equal collection A
minus collection B. Collection A already has the 'Limit to collection' used
in order to create itself. I want to further limit A by excluding B. Suppose
I want to send a package to A plus C. Any help is appreciated.

Thanks,
George
.

Relevant Pages

  • RE: How to combine existing collections to include or exclude...
    ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... When you refresh you will have a new collection with A, computers minus the ... will see if I can't just send you the collection queries and the query ...
    (microsoft.public.sms.admin)
  • RE: How to combine existing collections to include or exclude...
    ... is selecting the computers in my remote offices via AD but limits it only to ... select the query and say "computer name" not it limited ... This will grab all the computers that are in the limited collected minus the ...
    (microsoft.public.sms.admin)
  • RE: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... is selecting the computers in my remote offices via AD but limits it only to ... then edit the collection and do a query "Sub selected values" you can then ... This will grab all the computers that are in the limited collected minus the ...
    (microsoft.public.sms.admin)
  • Re: Distribute to user account objects in specific AD group in SCC
    ... For your second query, perhaps try using the subselect 'not in' ... This gave me a list of all the computers in the AD group. ... It does NOT work the same way as users in a usergroup. ... problem upon removing the computer account from the AD group and invoking ...
    (microsoft.public.sms.admin)
  • Re: Access to a custom table
    ... Create a collection based on this query for machines you want to include: ... "Tony" wrote: ... Let say I have computers named "A, B, C, D" in the database. ... > that has the NOT subselect query. ...
    (microsoft.public.sms.admin)