Powershell to export Teams User data

Question

Hi Experts,

Would you please help me to get the PowerShell script to pull out the following information into a CSV file in proper format?
We have around 3+ Lakhs user count and the script should run with the Teams Module 4.0.0

UserPrincipalName
SipAddress
OnPremLineUri
LineUri
PhoneSystemLicense
EnterpriseVoiceEnabled
TeamsCallingPolicy
OnlineVoiceRoutingPolicy
TenantDialPlan
TeamsCallParkPolicy
DialOutPolicy
TeamsMeetingPolicy
TeamsACLicenseType
TeamsMessagingPolicy
TeamsMeetingBroadcastPolicy
TeamsAppPermissionPolicy
TeamsCortanaPolicy
TeamsUpgradePolicy
OnlineVoicemailPolicy
HostingProvider
InterpretedUserType
MCOValidationError
City

Thanks in advance...!

Regards,
MS

Answer 1

Hello @MS

As far as I know there are no such commands by default, but you could find a lot of scripts publisher around in order to extract reports of your channels/teams. There is a lot of information in the microsoft techcommunity, have a look here:

Get all Teams and channel information using PowerShell
https://techcommunity.microsoft.com/t5/microsoft-teams/get-all-teams-and-channel-information-using-powershell/m-p/1312145

Get-Team
https://learn.microsoft.com/en-us/powershell/module/teams/get-team?view=teams-ps

Nice way to get a list of all our Teams and their info:
https://techcommunity.microsoft.com/t5/microsoft-teams/is-there-any-nice-way-to-get-a-list-of-all-our-teams-and-their/m-p/388933

Hope this helps with your query!

----------

--If the reply is helpful, please Upvote and Accept as answer-