Directly assigned or Inherited Office 365 Licenses ?

You don’t need to save the script in .ps1 file
0/ connect-msolservice
1/ copy the script : function Get-LicensePlan{…} and pass directly in your powershell console
2/ copy the script : function Get-LAPATH{…} and pass it directly in your powershell console
3/then run the cmdlet testuser@mydomain.com | Get-LAPath

LikeLike

To export, use this version of the script:

function Get-LicensePlan {
param (
[Parameter(Mandatory=$true)]
[String]$SkuId,
[Parameter(mandatory=$true)]
[String]$TenantName
)

Switch($SkuId){
“$($TenantName):AAD_PREMIUM” {return “AAD Premium P1”}
“$($TenantName):AX7_USER_TRIAL” {return “D_AX7.0 TRIAL”}
“$($TenantName):DYN365_ENTERPRISE_P1_IW” {return “D365 ETR P1”}
“$($TenantName):DYN365_RETAIL_TRIAL” {return “D365 CRM TRIAL”}
“$($TenantName):EMS” {return “EMS_E3”}
“$($TenantName):EMSPREMIUM” {return “EMS_E5”}
“$($TenantName):DESKLESSPACK” {return “F1”}
“$($TenantName):STANDARDPACK” {return “E1”}
“$($TenantName):ENTERPRISEPACK” {return “E3”}
“$($TenantName):ENTERPRISEPREMIUM” {return “E5”}
“$($TenantName):FLOW_FREE” {return “FLOW FREE”}
“$($TenantName):INTUNE_A_VL” {return “INTUNE”}
“$($TenantName):MCOMEETADV” {return “SFB PSTN Conf”}
“$($TenantName):MICROSOFT_BUSINESS_CENTER” {return “MBC”}
“$($TenantName):POWER_BI_PRO” {return “PBI PRO”}
“$($TenantName):POWER_BI_STANDARD” {return “PBI STD”}
“$($TenantName):POWERAPPS_INDIVIDUAL_USER” {return “PAPPS IND User”}
“$($TenantName):POWERAPPS_VIRAL” {return “PAPPS and LOGIC FLOW”}
“$($TenantName):PROJECTPREMIUM” {return “PJ Online”}
“$($TenantName):STREAM” {return “STREAM”}
“$($TenantName):VISIOONLINE_PLAN1” {return “VISIO P1”}
“$($TenantName):WACONEDRIVESTANDARD” {return “OD P1”}
“$($TenantName):WIN_DEF_ATP” {return “WDF ATP”}
default {return $SkuId.Replace(“$($TenantName):”,””)}
}
}

function Get-LAPATH{

[CmdletBinding()]

Param(
[Parameter(Mandatory=$true, ValueFromPipeline=$true)]
[string]$UPN,
[Parameter(Mandatory=$true)]
[string]$ExportPath

)

Begin{
Get-Date
Write-Host “## Data processing stated at $(Get-date)” -ForegroundColor Blue
Write-Host “”
$TenantName = ((Get-MsolAccountSku)[0].AccountSkuId -split(‘:’))[0]
}

Process{

Write-Host “”
Write-Host “Working on $UPN” -ForegroundColor Green
$User = Get-MsolUser -UserPrincipalName $UPN

#Getting assignment paths
$LicensesTab = $null
$LicensePlan = $null
$LicTabCount = 0
$LicensesTab = $User.Licenses | Select-Object AccountSkuId, GroupsAssigningLicense

if($LicensesTab){

Write-Host “License Enabled : True” -ForegroundColor Yellow

$i = 0 #(Measure-Object -InputObject $LicensesTab).Count
$LicTabCount = $LicensesTab.AccountSkuId.Count

Do{
#Getting License Plan
$LicensePlan = Get-LicensePlan -SkuId $LicensesTab[$i].AccountSkuId -TenantName $TenantName

#Getting License Paths
[System.Collections.ArrayList]$LicensePath = @()

if($LicensesTab[$i].GroupsAssigningLicense){
foreach ($Guid in $LicensesTab[$i].GroupsAssigningLicense.guid){

if($Guid -eq $User.ObjectId.Guid){
$LicensePath.Add(“Direct”) | Out-Null
}
else {
$LicensePath.Add((Get-MsolGroup -ObjectId $Guid).DisplayName) | Out-Null
}
}
}
else{
$LicensePath.Add(“Direct”) | Out-Null
}

Write-Host $LicensePath
Write-Host “$LicensePlan : $($LicensePath.ToArray() -join “,”)” -ForegroundColor Yellow #$([String]::Join(“,”,$LicensePath.ToArray()))
New-Object -TypeName PSObject -Property @{
“UserPrincipalName” = $UPN
“LicensePlan” = $LicensePlan
“AssignmentPath” = $($LicensePath.ToArray() -join “,”)
} | Export-Csv -Path $ExportPath -Encoding UTF8 -Delimiter “;” -NoTypeInformation -Append

$i++
}
while ($i -ne $LicTabCount)
}
else {
Write-Host “License Enabled : false” -ForegroundColor Red
New-Object -TypeName PSObject -Property @{
“UserPrincipalName” = $UPN
“LicensePlan” = “”
“AssignmentPath” = “”
} | Export-Csv -Path $ExportPath -Encoding UTF8 -Delimiter “;” -NoTypeInformation -Append
}

}

End{
Write-Host “”
Write-Host “## Data Processing ended on $(Get-Date)” -ForegroundColor Blue
}

}

“upn1″,”upn2” | Get-LAPATH -ExportPath “c:\file.csv”

LikeLike