An Office 365 admin perform one repetitive task on the Azure AD PowerShell is to generate license report from Office 365. Two simple Cmdlets Get-MsolUser and Get-MsolAccountSku can be used to generate many reports. This article uses variation of these Cmdlets to extract license report.
Connect to Exchange Online Services
Import-Module MSOnline
Connect-msolservice
Find out what licenses are available for you to consume from Office 365 tenant.
Get-MsolAccountSku | Format-Table AccountSkuId, SkuPartNumber
Generate a license report for all users with Office 365 licenses
Get-MSOLUser –MaxResults 100000 | select-object Displayname,userprincipalname,islicensed,{$_.Licenses.AccountSkuId}| Export-CSV c:\temp\userlist.csv –NoTypeInformation
Once CSV is generated, just filter the report to suit your need.
Find Consumed Licenses for specific license type
Get-MsolAccountSku | Where-Object {$_.SkuPartNumber -eq “ENTERPRISEPACK”}
Find all consumed licenses
Get-MsolAccountSku
Find all licenses users in a specific domain
Get-MsolUser -MaxResults 100000 –DomainName domain.com.au | Select-Object Displayname,UserPrinciPalname,IsLicensed
Find out all users who consumed any licenses
Get-MsolUser -all | where {$_.isLicensed -eq “True”} | Select-Object DisplayName,UserPrincipalname,IsLicensed
Find out all users in a specific location who consumed any licenses
Get-MsolUser -all | where {$_.UsageLocation -eq “Australia”} | Select-Object DisplayName,UserPrincipalname,IsLicensed,UsageLocation
