Get-MsOUsers-Html

MSOnline: HTML report of Azure AD users

Script

#Requires -Version 5.1

[CmdletBinding()]
Param(
    [switch]$HasErrorsOnly,
    [switch]$OnlyDeletedUsers,
    [switch]$OnlyUnlicensedUsers,
    [switch]$LicenseReconciliationNeededOnly,
    [ValidateSet('All','EnabledOnly','DisabledOnly')]
    [string]$Filter = 'All',
    [guid]$TenantId
)

Process {
    try {
        [hashtable]$getArgs = @{'ErrorAction' = 'Stop'; 'TenantId' = $TenantId}
        if ($HasErrorsOnly) { $getArgs.Add('HasErrorsOnly', $true) }
        if ($OnlyDeletedUsers) { $getArgs.Add('ReturnDeletedUsers', $true) }
        if ($OnlyUnlicensedUsers) { $getArgs.Add('UnlicensedUsersOnly', $true) }
        if ($LicenseReconciliationNeededOnly) { $getArgs.Add('LicenseReconciliationNeededOnly', $true) }
        if ($Filter -ne 'All') { $getArgs.Add('EnabledFilter', $Filter) }

        $result = Get-MsolUser @getArgs | Select-Object DisplayName, UserPrincipalName, Department, Title, ObjectId, IsLicensed
        if ($null -eq $result -or $result.Count -eq 0) { Write-Output "No users found"; return }
        Write-Output ($result | ConvertTo-Html -Fragment)
    }
    catch { throw }
}

Customize

HasErrorsOnly switch

Off

Only users with validation errors

OnlyDeletedUsers switch

Off

Only users in recycle bin

OnlyUnlicensedUsers switch

Off

Only users without a license

LicenseReconciliationNeededOnly switch

Off

Only users needing license reconciliation

Filter string

Filter by enablement status

TenantId guid

Unique ID of the tenant