Export Office 365 Licenses

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