December 18 2012

Decline / exclude an update in SCCM 2012

Recently I needed to decline an update in SCCM 2012 so it wouldn’t install or get approved again via an Automated Deployment Rule.

Remove / Decline Update

  1. Go to All Software Updates
  2. Find the Update you want to decline
  3. Highlight and right-click, then select Edit Membership
  4. Uptick all of the Software Update Groups and click OK

Stop automatic approval via Automated Deployment Rule

  1. Set the Custom Severity for the update you want to exclude to Low
  2. In the ADR(s),  add the Custom Severity field and set it to None. This will exclude any update(s) that are set to Low.

 

 

 



----------------------------------------------------------------------------
I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.

----------------------------------------------------------------------------

February 25 2011

Create a SCCM collection that excludes members of another collection

To create a SCCM collection that excludes members of another collection, use the below query. In my example the collection ID is P000004C. This is useful when combining with the ‘limit collection’ function.

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.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_P000004C)