1. Home
  2. Exchange / Office 365
  3. Export CSV of Users and Assigned License in Office 365
  1. Home
  2. PowerShell
  3. Export CSV of Users and Assigned License in Office 365

Export CSV of Users and Assigned License in Office 365

Description

This article will show you how to export a list of your Office 365 user and what license is assigned to them.

Resolution

  1. Connect to Office 365 with PowerShell
  2. Enter in the following:

    GetUsersLicenses
  3. The CSV is set to save at C:\Scripts
    exportedcsv
  4. You will get a CSV of your results, the first column will show the user and the second column will show the license
    CSVresults
Information

EXCHANGESTANDARD = Exchange Online Plan 1

STANDARDPACK = Office 365 Enterprise E1

ENTERPRISEPACK =  Office 365 Enterprise E3

Updated on July 26, 2017

Was this article helpful?

Related Articles

Leave a Comment