Kaffeeundcode
Script Library
PowerShell 01.06.2026

Script Workspace

Get TeamsUsersByOffice

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

158_Get-TeamsUsersByOffice.ps1

<#
.SYNOPSIS
    Teams Users By Office

.DESCRIPTION
    Ruft Teams Users By Office aus der Teams-Telefonie ab.

.NOTES
    File Name : 158_Get-TeamsUsersByOffice.ps1
    Author    : Kaffeeundcode
    Version   : 1.0
#>

param(
    [string]$OutputPath = "$PSScriptRoot/158_Get-TeamsUsersByOffice.csv",
    [int]$Top = 25,
    [switch]$SkipConnect
)

. "$PSScriptRoot/000_TeamsTelephonyHelper.ps1"

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


$Items = @(Get-CsOnlineUser -ResultSize Unlimited)
$Result = Group-TtByPath -Items $Items -Path "Office" -Label "TeamsUsersByOffice"

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