Kaffeeundcode
Script Library
PowerShell 01.06.2026

Script Workspace

Export TeamsUsersWithPhoneNumbers

Review the purpose, inspect the code, then test it safely in your own tenant.

167_Export-TeamsUsersWithPhoneNumbers.ps1

<#
.SYNOPSIS
    Teams Users With Phone Numbers

.DESCRIPTION
    Exportiert Teams Users With Phone Numbers aus der Teams-Telefonie.

.NOTES
    File Name : 167_Export-TeamsUsersWithPhoneNumbers.ps1
    Author    : Kaffeeundcode
    Version   : 1.0
#>

param(
    [string]$OutputPath = "$PSScriptRoot/167_Export-TeamsUsersWithPhoneNumbers.csv",
    [int]$Top = 25,
    [switch]$SkipConnect
)

. "$PSScriptRoot/000_TeamsTelephonyHelper.ps1"

Ensure-TtCommand -Commands @("Get-CsOnlineUser")
Initialize-TtSession -SkipConnect:$SkipConnect

$PropertyMap = ([ordered]@{
    DisplayName = "DisplayName"
    UserPrincipalName = "UserPrincipalName"
    LineURI = "LineURI"
    OnPremLineURI = "OnPremLineURI"
    EnterpriseVoiceEnabled = "EnterpriseVoiceEnabled"
    HostedVoiceMail = "HostedVoiceMail"
    UsageLocation = "UsageLocation"
    Department = "Department"
    Office = "Office"
    City = "City"
    Country = "Country"
})


$Items = @(Get-CsOnlineUser -ResultSize Unlimited)

$Items = Where-TtHasValue -Items $Items -Path "LineURI"

$Result = Select-TtProps -Items $Items -PropertyMap $PropertyMap

$Result = @($Result | Sort-Object DisplayName)

if ($OutputPath) {
    Export-TtData -Data $Result -OutputPath $OutputPath
    Write-Host "Export abgeschlossen: $OutputPath" -ForegroundColor Green
} else {
    Write-TtPreview -Data $Result -Top $Top
}