Re: Collection Question
From: Rune Norberg (runeno_at_online.no_NOSPAM)
Date: 08/24/04
- Next message: Evan [MSFT]: "Re: Sitecomp.log Error message. Please Help!"
- Previous message: SPO: "Re: Adding a second Site Server on A DC"
- In reply to: Dave Halperin: "Re: Collection Question"
- Next in thread: IcculusDC: "Re: Collection Question"
- Reply: IcculusDC: "Re: Collection Question"
- Messages sorted by: [ date ] [ thread ]
Date: 24 Aug 2004 20:34:20 +0200
Well - this will only find those clients that are in a spesific OU - it will
not exclude those in a spesific SMS collection.
You can use the following query to also get the exclution part:
select distinct ResourceId, ResourceType, Name, SMSUniqueIdentifier,
ResourceDomainORWorkgroup, Client from SMS_R_System where SystemOUName like
"%/COMPUTERS" and Name not in (select sys.name from SMS_R_SYSTEM as sys
right join SMS_CM_RES_COLL_SMS000GS as coll on sys.resourceid =
coll.resourceid)
You will have to change 2 parameters: %/COMPUTER with whatever OU you want
and SMS000GS with the collection ID of the collection you want to exclution
collection.
(If you don't know how to find the collection id - add the /SMS:nodeinfo=1
on the command line that starts the SMS console (after .....SMS.MSC),
restart the SMS Admin Console and use properties on the collection. You will
now have a new tab called "Node Info" - use that and look at the Store
Number parameter (line 2 for me) to get the collection id.)
Rgds,
Rune
"Dave Halperin" <Dave_Halperin@bose.com> wrote in message
news:OhvxXXgiEHA.3320@TK2MSFTNGP11.phx.gbl...
> Very easy to do. Create a collection. Then base that collection on a
> query. Go to the query tab under membership > click "edit query
> statement"
> (resource class "System Resource") > click criteria, then the yellow star
> to
> add.
>
> Criterion Type = Simple value
> Where= click select > Attribute class = System resource > Attribute =
> System
> OU Name ( gotta scroll down to it.) > Operator = is equal to > Value =
> (name
> of OU) or you can click on values to see what SMS has for OU names.
>
> Once chosen, click OK all the way until everything is closed.
>
> That should do it.
>
> "IcculusDC" <icculusdc@verizonREMOVENOSPAM.net> wrote in message
> news:qFKWc.13$2B4.7@trnddc06...
>> I am looking to base a collection on query for all computers that are a
>> member of a specific OU and are NOT a member of a specific SMS
>> collection.
>> Is this possible? If so it would be great if someone could steer me in
>> the
>> right direction. I have not been able to figure this out and am not sure
> if
>> I am overlooking something or if it cannot be done.
>>
>>
>
>
- Next message: Evan [MSFT]: "Re: Sitecomp.log Error message. Please Help!"
- Previous message: SPO: "Re: Adding a second Site Server on A DC"
- In reply to: Dave Halperin: "Re: Collection Question"
- Next in thread: IcculusDC: "Re: Collection Question"
- Reply: IcculusDC: "Re: Collection Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
