Create Deployment from csv

#

# Press 'F5' to run this script. Running this script will load the ConfigurationManager

# module for Windows PowerShell and will connect to the site.

#

# This script was auto-generated at '2021-02-19 16:27:13'.

# Uncomment the line below if running in an environment where script signing is

# required.

#Set-ExecutionPolicy -ExecutionPolicy Bypass -Scope Process

# Site configuration

# Site code

$SiteCode = "%SiteCode%"

# SMS Provider machine name

$ProviderMachineName = "%CM_ServerFQDN%"

# Customizations

$initParams = @{}

#$initParams.Add("Verbose", $true) # Uncomment this line to enable verbose logging

#$initParams.Add("ErrorAction", "Stop") # Uncomment this line to stop the script on any errors

# Do not change anything below this line

# Import the ConfigurationManager.psd1 module

if((Get-Module ConfigurationManager) -eq $null) {

Import-Module "$($ENV:SMS_ADMIN_UI_PATH)\..\ConfigurationManager.psd1" @initParams

}

# Connect to the site's drive if it is not already present

if((Get-PSDrive -Name $SiteCode -PSProvider CMSite -ErrorAction SilentlyContinue) -eq $null) {

New-PSDrive -Name $SiteCode -PSProvider CMSite -Root $ProviderMachineName @initParams

}

# Set the current location to be the site code.

Set-Location "$($SiteCode):\" @initParams

#Script to create deployment to SCCM Application from CSV.

#CSV file supports multiple entries.

$csv = Import-Csv -Path "&Path%\DeployTemplate.csv"

ForEach ($item In $csv)

{

$create_deployment = New-CMApplicationDeployment -Name $item.Name -AvailableDateTime $item.AvailableDateTime -CollectionName $item.CollectionName -DeployAction $item.DeployAction -DeployPurpose $item.DeployPurpose -Comment $item.Comment

Write-Host -ForegroundColor Green "Deployment $($item.Name) for Collection $($item.CollectionName) created!"

}

DeployTemplate.csv

Name,AvailableDateTime,CollectionName,DeployAction,DeployPurpose,Comment

"%SCCMName%","01/01/2020 00:00:00",%CollectionName%,Install,Required,AutoCreated