|
Rickym61 -> RE: Is this possible? Trying to make a query to exclude... (9/26/2008 6:24:49 PM)
|
If I understand correctly, this should work (borrowed from the sms email archive lists) no need to collection limit it, the subselect handles it.
This article explains its further http://www.myitforum.com/articles/1/view.asp?id=179
1. Create a collection where clients are to be excluded, i.e. - "Excluded Clients"
2. Hunt down the Collection ID for the new collection named "Excluded Clients"
a. Youcan use the SMS report titled "All Collections" that lists the Collection Name and Collection ID.
b. Or, add the following switch to the end of your SMS console .msc: Properties | Target "/SMS:NodeInfo=1" (no quotes needed) - http://support.microsoft.com/kb/216242
You can then do Properties | Node Information on your new collection to get the Store Name or Collection ID (this is alot easier than 2a)
3. Create another collection and call it "Clients not excluded"
a. Membership Rules - New Query - Edit Query Statement - Criteria -Star Burst (Properties)
b. Criterion Type: Subselected Values
c. Attribute class: System Resource
d. Attribute: Resource ID
e. Operator: is not in
f. Subselect: paste this into the dialogue box without the quotes
"select ResourceID from SMS_CM_RES_COLL_SMS1234" then change the SMS1234 to be the Collection ID from step 2 above.
g. OK all of the way out and Update Collection Membership and Refresh
|
|
|
|
