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

Thanks! Could you explain how to do that?

"Kim Oppalfens <MVP>" wrote:

Only problem is that your exclusion list is static.
By excluding based on collection id you even could do this in a dynamic
fashion.

--
Kim Oppalfens
Telindus Belgium
MVP Windows Server System - SMS
"George Phillips" <GeorgePhillips@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:33091D84-6F38-45E6-86F3-D7CCF78E3F1F@xxxxxxxxxxxxxxxx
Yes, that worked! Thanks, again, for your assistance.

"Matthew Hudson" wrote:

How does this work........

To do it with only 2 collections do this

Collection A: Servers in remote location
Collection B: Servers you want minus the ones you don't want


New collection B
New Rule:
Limted to Collection A

[edit query statement/Criteria]
Cireterion type: List of Values
Where: Computer System (attribute = name)
Operator (is not in)
Value to add: 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
ones on your list

------------------------------------------------------------------------------
"George Phillips" wrote:

That would be great! I appreciate your willingness to help.

"Matthew Hudson" wrote:

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...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... 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...
    ... 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...
    ... Here is a working query: ... machines to exclude, the primary collection would be modified as well. ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ...
    (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: Collection based upon pcs with missed patch
    ... that showed me every pc we have...over 9500 computers ... I know by looking at software updates that we have successfully ... On Feb 21, 1:34 pm, Matthew Hudson ... another query if you have ITMU installed? ...
    (microsoft.public.sms.inventory)