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

Question

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.

Answer 1

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"