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

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...
    ... 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: Tool to check why queries miss results?
    ... :> that are supposed to result from the query before the query ... consists of the UNION and MINUS operators to returns (set1 minus set2) union ...
    (comp.databases.oracle.tools)
  • Re: Improving performance of queries
    ... 6475 SELECT STATEMENT Cost= 6475 ... Such query takes 15 mn to run. ... This is the most efficient plan for the given query. ... as MINUS is a SET operations and a ...
    (comp.databases.oracle.server)