Office 365 License Reporting with the MSOnline Module

MSOnlineLicenseReporting.ps1

#Get the available Skus and Usage from the tenant
Get-MsolAccountSku | Select-Object SkuPartNumber,ActiveUnits,ConsumedUnits,@{n='AvailableUnits';e={$_.ActiveUnits-$_.ConsumedUnits}} -OutVariable AllSkus

#Specify which skus you want to specifically report on
$SkusToReportOn = @('STANDARDPACK','ENTERPRISEPACK','ENTERPRISEPREMIUM')
#Report on Users/Sku Usage
$AllLicensedUsers = Get-MsolUser -all | ? IsLicensed -eq $true | Select DisplayName,UserPrincipalName,IsLicensed,@{n='Skus';e={@($_.Licenses.AccountSkuID)}}
#Below expands licensed users so that for each Sku in SkusToReportOn there would be an entry for the user if the user has more than one of them assigned
$ExpandedSkuUsers = @(
 foreach ($lu in $AllLicensedUsers)
 {
    $SkusHeld = @()
    foreach ($s in $SkusToReportOn)
    {
        $splitskus = @($lu.skus | ForEach-Object {$_.split(':')[1]})
        if ($splitskus -contains $s)
        {
            [pscustomobject]@{
                DisplayName = $lu.DisplayName
                UserPrincipalName = $lu.UserPrincipalName
                IsLicensed = $lu.IsLicensed
                Sku = $s
                AllSkus = $($splitskus -join ';')
            }
            $SkusHeld += $s
        }
    }
    if ($SkusHeld.Count -eq 0)
    {
        [pscustomobject]@{
            DisplayName = $lu.DisplayName
            UserPrincipalName = $lu.UserPrincipalName
            IsLicensed = $lu.IsLicensed
            Sku = $null
            AllSkus = $($splitskus -join ';')
        }
    }
 })
#Counts Per License Sku
$ExpandedSkuUsers | group sku -NoElement
#Users with License Detail (one object per user/SkusToReportOn)
$ExpandedSkuUsers