This script is designed to work in harmony with the Export Sites and Subnets to CSV script I blogged about recently. The CSV file that is created by that script can then be used to import IP Subnet Boundaries and Groups with this PowerShell script.
Each Site will be Created as a Boundary Group and each Subnet listed with that Site in the CSV will be created as a IP Subnet Boundary associated to the Boundary Group.
Here is the Script:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
######################################################################################################### #Script Name: Import Boundaries and Boundary Groups from CSV # #Script Author: SCCMOG - Richie Schuster 06/03/2017 WWW.SCCMOG.COM # ######################################################################################################### #Script Usage: ImportBoundariesandGroups.ps1 -CSVParam MyCSV.csv # ######################################################################################################### #CSV Name accepted as first PARAM Param ( [parameter(mandatory=$true,HelpMessage="Please, provide your SiteCode.")][ValidateNotNullOrEmpty()][String]$SiteCode, [parameter(mandatory=$true,HelpMessage="Please, provide a CSV to import. It must be in the same folder as the script e.g. Sites.CSV")][ValidateNotNullOrEmpty()][String]$CSVParam ) # Check for elevation Write-Host "Checking for elevation" If (-NOT ([Security.Principal.WindowsPrincipal] [Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole(` [Security.Principal.WindowsBuiltInRole] "Administrator")) { Write-Warning "Oupps, you need to run this script from an elevated PowerShell prompt!`nPlease start the PowerShell prompt as an Administrator and re-run the script." Write-Warning "Aborting script..." Break } If ($CSVParam -ne ""){ #Import CSV $path = Split-Path -parent $MyInvocation.MyCommand.Definition $newpath = $path + "\$CSVParam" #Check location of CSV is valid. If (Test-Path $newpath){ $BoundaryList = Import-Csv -Path $newpath #Import ConfigMgr Module Import-Module "$($ENV:SMS_ADMIN_UI_PATH)\..\ConfigurationManager.psd1" #Set the current location to be the site code. Set-Location "$SiteCode`:" foreach ($_ in $BoundaryList){ #Check If Boundary Group Already Created $getbg = Get-CMBoundaryGroup -Name $($_.Name) #If no bounday group maching that name create it if ($getbg -eq $null){ New-CMBoundaryGroup -Description $($_.Name) -Name $($_.Name) } #Split on / $Subnet,$Bit = $_.Subnet.split('/',2) #Check if Boundary is already Created $getbn = Get-CMBoundary | where Value -eq $Subnet #If it is not then create new boundry and add it to Boundary Group if ($getbn -eq $null){ New-CMBoundary -DisplayName $($_.Name) -BoundaryType IPSubnet -Value $Subnet Add-CMBoundaryToGroup -BoundaryGroupName $($_.Name) -BoundaryName $($_.Name) } } } Else{ Write-Host "Please enter VALID CSV Name. Make sure it is in the same folder as this script." -ForegroundColor Cyan } } Else{ Write-Host "Please enter CSV Name. Make sure it is in the same folder as this script." -ForegroundColor Cyan } ############################################################################################################### |
Below is a demonstration of the Script complete:
