Export users licenses and information O365

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmail

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 

 

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmail

Leave a Reply

Your email address will not be published. Required fields are marked *

*