Export O365 mailboxes with assigned licenses types

Export O365 mailboxes with licenses types assigned

Or, PowerShell command to export O365 user’s mailboxes with license assignment details

Or, Export mailboxes with assigned license details

Descriptions: If you are looking for a simplest way of exporting all users’ mailboxes with license types assigned to them, this article is for you. You can use Azure Active Directory PowerShell command to export the mailboxes with licenses types assigned to them.

Steps:

Login to O365 server using Azure Active Directory PowerShell Administrative privileges.

Connect O365 Azure Active Directory

connect-msolservice

Run below command to get the report:

Get-MSOLUser -All | select userprincipalname,islicensed,{$_.Licenses.AccountSkuId} | export-csv d:\temp\userslicense.csv

You can change the export folder path if you have a different one.

Cheers, please write me back if you have query of feedback on this.