Export Office 365 User License Report With PowerShell

Using this PowerShell script you can export all licensed users with their Country, Assigned Licenses, License friendly name, Services, and Service Status to CSV file.

 
 
 
 
 
5 Star
(4)
2,300 times
Add to favorites
Office 365
12/6/2019
E-mail Twitter del.icio.us Digg Facebook
  • Add Country to this report
    2 Posts | Last post December 06, 2019
    • Good day to Microsoft, May i know how to add country column to this report ? 
    • Hi Ryan,
      Script has been updated to export a report with the country attribute. You can find the country attribute in 'Office 365 Users License Summary Report". Check out our new version.
  • Thank you
    1 Posts | Last post September 18, 2019
    • Thanks for this script it has saved me a load of time hunting this down this information for my commercial team :)
  • Company Field
    2 Posts | Last post August 08, 2019
    • When I export with the script, the Company field is blank... any idea why?
    • We assume you have added the Company field manually because we haven't used that attribute in this script. 
      
      Please share the changes you made in this script to review and help you better.
  • Thanks - possible typo
    2 Posts | Last post June 03, 2019
    • Thanks for this script it is helpful.  In the LicenseFriendlyName file there appears to be a cut-paste typo:  AAD_PREMIUM_P1 shows "P2".
      
      I'm unable to login to your website - Google login appears to actually be Disqus and doesn't allow me to login.  I'll have to check out the other posts/reports.
      
    • Thank you, Prentice, for pointing it out. We have updated the LicenseFriendlyName file.