Create ConfigMgr Servicing Plans with Excel and PowerShell

Last week I posted one example how to create ConfigMgr Servicing Plans with PowerShell. In this post I will show you how to create Servicin Plans using Excel.

Step 1 is to create a table like this

image

If you have that table with necessary information or if needed you can add more data, then simply save it as a CSV file and import the data to PowerShell.

 

Here is one quick and simple example how to create these Servicing Plans based on a CSV file and if needed create the Device Collections as well. This example also assumes that Software Updates Deployment Package already exists.

 

$ServicingPlans = Import-Csv C:\Scripts\Windows10ServicingPlans.csv -Delimiter ‘;’

 

$DeploymentPackage = Get-CMSoftwareUpdateDeploymentPackage -Name ‘Windows 10 1511 CB’

 

foreach($Plan in $ServicingPlans){

   

    <#

        New-CMCollection

            -Name $Plan.Name

            -CollectionType Device

            -LimitingCollectionName 'All systems'

    #>

   

    New-CMWindowsServicingPlan

        -Name $Plan.Name

        -CollectionName $Plan.Collection

        -EnabledAfterCreate $True

        -Language $Plan.Language

        -VerboseLevel AllMessages

        -SendWakeupPacket $True

        -RunType RunTheRuleAfterAnySoftwareUpdatePointSynchronization

        -DeploymentRing $Plan.Branch

        -DeploymentPackage $DeploymentPackage `

        -UpdateDeploymentWaitDay $Plan.DaysToWait

   

}

 

By | 2016-05-31T21:32:16+00:00 May 31st, 2016|Configuration Manager (SCCM)|0 Comments

About the Author:

Kaido Järvemets

Configuration Manager MVP

Leave A Comment