In order to Export users licenses and information from Office 365 you will have to use the following script.

 

First you will need to connect to MS Online service with a Global admin account

Connect-MsolService

image

 

Get-MsolUser -All |Where {$_.IsLicensed -eq $true } |Select DisplayName,UsageLocation,@{n=”Licenses Type”;e={$_.Licenses.AccountSKUid}},SignInName,UserPrincipalName,@{n=”ProxyAddresses”;e={$_.ProxyAddresses}}| Export-csv -Path C:ExportlicenseUsage.csv –notype

 

clip_image001

 

This will export a file called “ExportLicenseUsage.csv” to your C root drive. you can open this file with Microsoft Excel and find out all the useful information that you’re looking for.

Hope this helps Smile 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.