ConfigMgr ADR Patchday Calculator with Gant-chart

UPDATE 19.04.2018: Excel Sheet is now available with English day names. Thank you for the feedback Fadi
When you configure your Automatic Deployment Rule (ADR) for the monthly Patchday, then you have to specify multiple times and timespans. Sometimes it is not so easy to check and verify these settings. I created a Patchday calculator sheet to get all deployment dates for all pilot and production groups in a year and to have a Gant-chart overview.

Patchday Calculator Gant Chart

 

The calculated deployment dates can also be used for creating a change request:

Calculated ConfigMgr Deployment Deadline for Patchday

 

All these Information can be calculated by filling out a few parameters:

Patchday Calculator Configuration

 

The following parameters are available (blue background):

  1. Year – For which year would you like to calculate the deployment dates?
  2. ADR Delay to MS Patchday(Days) – When should I execute the Automatic Deployment Rule?
    I prefer to plan the execution directly on the evening of the second Tuesday. If you choose another “second weekday” in the month, it could happen, that it will be before the second Tuesday. If you would like to start the ADR later, then I switch to a “third weekday”. In my time planer Excel sheet, I call this delay “ADR Delay to MS Patchday(Days)”. It can be entered in days.
  3. Collection Name – You can customize the collection names (In my example prefixed with SUM) in the first column to meet your requirements
  4. Available from Execution (Hours) – Her you have to specify the minutes between the ADR execution and the availability time of the deployment.
  5. Deadline from Available Time (Hours) – These values should be the delay in hours between the Availability Time and the planned deadline of the deployment.

As you can see, you will get a nice documentation and you can verfy your settings in a few seconds. You can download the Excel Sheet here.

Feedback is welcome! Smile

Thomas Kurth

Thomas Kurth

I’m a consultant, trainer and architect formodern workplace and enterprise mobility projects with Microsoft Technologies in the past eight years. I love to push and design the modern workplace based on Windows 10, EM&S and O365 for my customers which is the only answer for the current security threats, agile world and the fast-changing business requirements of my customers. Important for me is to simplify and automate the operational processes, because there are the highest costs.
Enterprise Adminstrator ExpertMCTCMCE

0 Comments

Leave a 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.

Subscribe
Hosting sponsored by:
Archive