Automate Auto Attendant Holiday Setup

I have seen many people looking for help with this issue (including myself) and finally being frustrated enough I have built a PowerShell script that will allow the management of a large number of Auto Attendants Holiday settings. At first, I  tried using the export/import-CSAutoAttendentHolidays commands but that action creates a new holiday instance for each AA and does not set the call flow, which means all calls just get disconnected with no message being read. Instead, I had to create a whole call flow based off  the documentation on https://learn.microsoft.com/en-us/powershell/module/skype/new-csautoattendantcallhandlingassociation?view=skype-ps

While I am not an expert in powershell, and am sure there are others who could improve this but as I have yet to see this information online I thought I would share what I have.

Prep

First: You will need to setup your list of Holidays in Teams Admin Center to reference. These can be updated each year to have the dates set for the upcoming year.

Second: You will need 2 CSV files. The first contains the list of Auto Attendants that you want to set the holidays for. This CSV will need a column labeled "AutoAttendantIdentity" which contains all the object ID's for the auto attendants. To find the object ID's you can use the Get-CsAutoAttendant commandlet. The second CSV will contain your list of holidays to be added. Must include columns: "MenuName" (Holiday Name) " CallFlowName" (Holiday Name) and "ScheduleID" (Object ID of Holidays.) To get the Object ID's of the Holidays you have created use the Get-CsOnlineScheudule to see a list of all operation hours in your environment, holidays will all be "FixedSchedules" and you can ignore the many "WeeklyRecurrentSchdules" in your tenant.

Third: In our organization I created an Auto Attendant named "Holiday Message" which is where all calls will be sent to during holiday hours. This allows for easy message management and will be referenced by all Holiday call flows the script will build.

Script

#Paths to CSV File
$csvFile1 = "C:\temp\AutoAttendants.csv" # List of auto attendants to change. Must include column called "AutoAttendantIdentity" containing Object ID's for the Auto Attendants
$csvFile2 = "C:\temp\ScheduleIDs.csv" # List of Holidays to be added. Must include columns: "MenuName" (Holiday Name) " CallFlowName" (Holiday Name) "ScheduleID" (Object ID of Holidays)

#Import list of Auto Attendants
$autoAttendantIdentities = Import-Csv $csvFile1 | Select-Object -ExpandProperty AutoAttendantIdentity

#Loop through each Auto Attendant
foreach ($autoAttendantId in $autoAttendantIdentities) {
$autoAttendant = Get-CsAutoAttendant -Identity $autoAttendantId

#Send calls to "holiday Message" Auto Attendant
$callableEntityId = Find-CsOnlineApplicationInstance -SearchQuery "Holiday Message" -MaxResults 1 | Select-Object -Property Id
$callableEntity = New-CsAutoAttendantCallableEntity -Identity $callableEntityId.Id -Type ApplicationEndpoint

#Load List of Holidays and create call flow with unique naming for each holiday
Import-Csv $csvFile2 | ForEach-Object {

# Generate a unique name for each call flow
$uniqueId = get-random -Minimum 100 -Maximum 999
$uniqueName = $_.CallFlowName + - + $uniqueId

#Create call flow
$menuOption = New-CsAutoAttendantMenuOption -Action TransferCallToTarget -CallTarget $callableEntity -DtmfResponse Automatic
$menu = New-CsAutoAttendantMenu -Name $_.MenuName -MenuOptions $menuOption
$callFlow = New-CsAutoAttendantCallFlow -Name $uniqueName -Menu $menu
$callHandlingAssociation = New-CsAutoAttendantCallHandlingAssociation -Type Holiday -ScheduleId $_.ScheduleId -CallFlowId $callFlow.Id

$autoAttendant.CallFlows += $callFlow
$autoAttendant.CallHandlingAssociations += $callHandlingAssociation
}

#Apply Changes to Auto Attendant
Set-CsAutoAttendant -Instance $autoAttendant
}

Notes:

- If the auto attendant is set to force listeners to hear all of the greeting before picking an option it will cause the script to fail at that point.

- If you do not have an auto attendant called "Holiday Message" the script will fail. 

- It will update you at each successful Auto Attendant completed.

- Each call flow had to have a unique name which is why the random number generator is used

Dale_LTU