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

Sunil Chittor 96 Reputation points
2020-12-10T08:05:37.857+00:00

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
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,462 questions
0 comments No comments
{count} votes

Accepted answer
  1. Sunil Chittor 96 Reputation points
    2020-12-18T08:00:53.077+00:00

    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"


0 additional answers

Sort by: Most helpful