Thank you so much it is working fine.
Regards Rajan K From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: 25 October 2013 01:28 To: [email protected] Subject: RE: [mssms] Exclude Collection Query - SCCM That's not an option in 2007. As someone else mentioned, you will need to create a collection called "exclusions" or whatever you want to call it, add the computers to the collection (Right click tools would be the easiest way), then set your other collection (not All Systems, a new collection) up with this membership query rule: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SY STEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM .Client from SMS_R_System where SMS_R_System.ResourceId not in (SELECT ResourceID FROM SMS_CM_RES_COLL_COLLID) and SMS_R_System.Client = 1 Switch "COLLID" above with the collection ID of your exclusions collection. Mike From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Rajan K Sent: Thursday, October 24, 2013 12:29 PM To: [email protected] <mailto:[email protected]> Subject: RE: [mssms] Exclude Collection Query - SCCM Where to find this option? Please mention the path.. Regards Rajan K From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dzikowski, Michael Sent: 25 October 2013 00:11 To: [email protected] <mailto:[email protected]> Subject: RE: [mssms] Exclude Collection Query - SCCM From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Harjit Dhaliwal Sent: Thursday, October 24, 2013 2:23 PM To: [email protected] <mailto:[email protected]> Subject: Re: [mssms] Exclude Collection Query - SCCM Create a collection and add those 50 as members. Then, use that collection to exclude as Michael has suggested. -Harjit On 10/24/2013 2:17 PM, Rajan K wrote: Hi, All systems means from the list of 1000 PCs, I need exclude some 50 PCs. Regards Rajan K From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Marcum, John Sent: 24 October 2013 23:43 To: '[email protected] <mailto:[email protected]> ' Subject: RE: [mssms] Exclude Collection Query - SCCM You that as if you are deploying software to the All Systems collection. I hope that's not the case. _____ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP _____ From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Rajan K Sent: Thursday, October 24, 2013 12:49 PM To: [email protected] <mailto:[email protected]> Subject: [mssms] Exclude Collection Query - SCCM Hi, I need to create Exclude collection from all systems to avoid installing some software. Example :- Adobe Acrobat :- PC1,PC2,PC3,...PC100 Exclude Adobe Acrobat :- PC2,PC5,PC57,PC72. Regards Rajan K _____ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. _____ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<image001.png>>

