PowerShell 1 liner to get AVD session host session information across all host pools. Pipe through ogv (Out-Gridview) to give you a filterable/sortable display
Get-AzWvdHostPool -PipelineVariable hpool | % { Get-AzWvdUserSession -HostPoolName
$hpool.name -ResourceGroupName
$hpool.ResourceGroupName }|select @{n='HostPool';e={$hpool.Name}},@{n='FriendlyName';e={$hpool.FriendlyName}},@{n='Location';e={$hpool.location}},UserPrincipalName,ApplicationType,CreateTime,SessionState,@{n='SessionId';e={split-path $_.Id -leaf }}