public/Get-Office365LicenseAssignment.ps1

<#
.SYNOPSIS
Find License information for all Licensed Office 365 Users
 
.DESCRIPTION
Find License information for all Licensed Office 365 Users
 
.EXAMPLE
Get-Office365LicenseAssignment
 
.NOTES
General notes
#>


function Get-Office365LicenseAssignment {
    [cmdletbinding()]
    param()

    try {
        $LicensedUsers = Get-MsolUser -All -ErrorAction Stop | Where-Object { $_.IsLicensed } | Sort-Object DisplayName
        $Groups = Get-MsolGroup -All

        $LicenseAssignment = foreach ($User in $LicensedUsers) {
            $UserGuid = $User.ObjectId.Guid
            foreach ($License in $User.Licenses) {
                $UserLicense = [PSCustomObject]@{
                    PSTypeName  = 'PSP-Office365-LicenseAssignment'
                    UserName    = $User.DisplayName
                    UPN         = $User.UserPrincipalName
                    LicenseSku  = $License.AccountSku.SkuPartNumber
                    LicenseName = (Convert-LicenseSku -LicenseSku $License.AccountSku.SkuPartNumber)
                }
                if (($null -eq $License.GroupsAssigningLicense) -OR ($UserGuid -eq $License.GroupsAssigningLicense.guid)) {
                    $UserLicense | Add-Member -MemberType NoteProperty -Name 'DirectAssigned' -Value $true
                    $UserLicense | Add-Member -MemberType NoteProperty -Name 'GroupAssigned' -Value $false
                    $UserLicense | Add-Member -MemberType NoteProperty -Name 'AssignedBy' -Value ''
                }
                else {
                    $UserLicense | Add-Member -MemberType NoteProperty -Name 'DirectAssigned' -Value $false
                    $UserLicense | Add-Member -MemberType NoteProperty -Name 'GroupAssigned' -Value $true
                    $UserLicense | Add-Member -MemberType NoteProperty -Name 'AssignedBy' -Value (($Groups.Where{ $_.ObjectId -eq $License.GroupsAssigningLicense.guid }).DisplayName)
                }
                $UserLicense
            }
        }
        $TypeData = @{
            TypeName                  = 'PSP-Office365-LicenseAssignment'
            DefaultDisplayPropertySet = 'UserName', 'LicenseName', 'DirectAssigned', 'GroupAssigned'
        }
        Update-TypeData @TypeData -ErrorAction SilentlyContinue
        $LicenseAssignment
    }
    catch {
        Write-Error "Connect to your Office 365 tenant using the MSOL module"
    }
}