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

Follow me


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.