question

SunilChittor-5672 avatar image
0 Votes"
SunilChittor-5672 asked LeGoascozErwanExternal-2363 commented

Need powershell command to export Multiple “Teams Call-Queues” data in to a .csv file

I used to export all call-queues data when it was on skype platform without any issues, but with Teams platform, when i run the command to export and pipe the data into a .csv FILE, it never exports "overflowactiontarget" & "Timeoutactiontarget" items. It populates those field sfor every call-queue as "Microsoft.Rtc.Management.Hosted.CallQueue.Models.CallQueue". The powershell i run is as below.

Get-CsCallqueue -first 100 | select-object Name,Identity,ApplicationInstances,RoutingMethod,DistributionLists,Agents,AgentsInSyncWithDistributionLists,AllowOptOut,AgentsCapped,AgentAlertTime,OverflowThreshold,OverflowAction,OverflowActionTarget,OverflowSharedVoicemailTextToSpeechPrompt,OverflowSharedVoicemailAudioFilePrompt,EnableOverflowSharedVoicemailTranscription,TimeoutThreshold,TimeoutAction,TimeoutActionTarget,TimeoutSharedVoicemailTextToSpeechPrompt,TimeoutSharedVoicemailAudioFilePrompt,EnableTimeoutSharedVoicemailTranscription,WelcomeMusicFileName,UseDefaultMusicOnHold,MusicOnHoldFileName |export-csv -notypeinformation -append "C:\temp\CQdata.csv"

Note: If i just run Get-CsCallQueue command without " | select-object ". It will display all the information, but if i want to export to a .csv file by running "| select-object" command, it never exports "overflowactiontarget" & "Timeoutactiontarget" items.

windows-server-powershell
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SunilChittor-5672 avatar image
0 Votes"
SunilChittor-5672 answered LeGoascozErwanExternal-2363 commented

Below is the script to export Call-queue configuration to a .csv file.

Get-CsCallqueue -first 100 | select-object Name,Identity,ApplicationInstances,RoutingMethod,DistributionLists,Agents,AgentsInSyncWithDistributionLists,AllowOptOut,AgentsCapped,AgentAlertTime,OverflowThreshold,OverflowAction,@{Label="OverflowactionTarget";Expression={($.OverflowactionTarget.Id)}}, @{Label="TimeoutActionTarget";Expression={($.TimeoutActionTarget.Id)}},OverflowSharedVoicemailTextToSpeechPrompt,OverflowSharedVoicemailAudioFilePrompt,EnableOverflowSharedVoicemailTranscription,TimeoutThreshold,TimeoutAction,TimeoutSharedVoicemailTextToSpeechPrompt,TimeoutSharedVoicemailAudioFilePrompt,EnableTimeoutSharedVoicemailTranscription,WelcomeMusicFileName,UseDefaultMusicOnHold,MusicOnHoldFileName |export-csv -notypeinformation -append "C:\temp\cqdata.csv"

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Very useful, thanks !

0 Votes 0 ·