Menu
CCMEXEC.COM – Enterprise Mobility
  • Home
  • General
  • Configuration Manager
  • Windows 10
  • Windows 11
  • Intune
  • GitHub
  • About
CCMEXEC.COM – Enterprise Mobility

Planning an upgrade of an application

Posted on November 15, 2010 by Jörgen Nilsson

Some of the challenges I often face when installing/upgrading an application are for instance:

  • LAN and WAN links must not be overloaded
  • Exclusions must be handled
  • A phased roll-out must be used to minimize the risks/performance impact on the WAN

To be able to do a phased installation/upgrade for instance the computer name can be used, for instance collections could be created based on the last number in the computer name, UUID or MAC address as long as it’s spread between sites/departments. Of course many other criteria’s could be used but the computer name is perhaps the most appropriate because it is possible to inform the users that computers with a name ending with 1 and 2 will be upgraded on a specific day. I have created these collection as subcollections to a collection called Rollout, keeping them for themselves makes it easy to reuse them.

Rollout3

Query example:
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.NetbiosName like “%2” or SMS_R_System.NetbiosName like “%3”

For the roll-out itself I create the following collections:

Upgrade list – computers that should be upgraded are added to this collection, for instance all computer in one of the collections based on computer names, or a specific computer that needs to be upgraded at a specific time because the user is for instance only in the office on Tuesdays. Empty queries which are limited to the Computer Names collections can be used to add computers in each of them, or by direct membership or specific AD-group.
Upgrade_4

Exclusion List – Computers that shouldn’t have the application upgraded can be placed here. This makes it much easier to add all other computers and have a simple overview of which computers are excluded.

Upgrade – the Collection that the actual upgrade is targeted to with a query that should do the following:

  • Include only computers added to the Upgrade list
  • Exclude the computers in the Exclusion list
  • Hold the query used to select the computers that for instance have Office 2007 installed, if applicable.

Planning1

The query I use in this example is limited to the “Microsoft Office 2010 Upgrade list” and contains the following query which excludes the computers in the “Microsoft Office 2010 Exclusion List”, “0010007B” should be replaced with the collection ID for the Exclusion list collection.

Upgrade3

Query:

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.Active = 1 and SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_0010007B)

Adding and additional condition to only include computers with Office 2007 Enterprise Edition installed the following query could be added to the query above. It would look as follows in the Query designer, the query can be downloaded here Office_query

Office_upgrade

I hope this post can inspire you to create a suitable upgrade scenario for your organisation.

2 thoughts on “Planning an upgrade of an application”

  1. Christoph Voigt says:
    November 19, 2010 at 1:19 pm

    It’s nice to see more usage of exclusion lists for software distribution within ConfigMgr.

    Reply
  2. Pingback: Divide a collection into multiple smaller collections in ConfigMgr 2012 via PowerShell | Nothing but ConfigMgr

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

My name is Jörgen Nilsson and I work as a Senior Consultant at Onevinn in Malmö, Sweden. This is my blog where I will share tips and stuff for my own and everyone elses use on Enterprise Mobility and Windows related topics.
All code is provided "AS-IS" with no warranties.

Recent Posts

  • New settings in Intune Security Baseline Windows 11 24H2 -2504
  • Managing extensions in Visual Studio Code
  • Reinstall a required Win32app using remediation on demand
  • Administrator protection in Windows 11 – First look
  • Remediation on demand script – ResetWindowsUpdate
©2025 CCMEXEC.COM – Enterprise Mobility | WordPress Theme by Superb Themes
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT