Blogxx902

1. Microsoft O365 Licenses
2. O365 License Types

As an Office 365 Administrator, often you are in the situation to get all licensed users with their assigned licenses and services. Using the O365 admin portal, you can get user’s license information, but you need to click each user to know about their license subscriptions and service status which is a cumbersome task. To ease your work, you can use PowerShell commands. Get-Msoluser will get the details of all Office 365 users and Where condition used to filter out licensed users alone. Now, you can export O365 licensed users to CSV file.

After your organization signs up for Microsoft 365, the admin can assign different Microsoft 365 licenses to each user account. The different licenses include different services, such as SharePoint in Microsoft 365 and Skype for Business Online. See the different Office 365 for business plans. Note: This topic is for Microsoft 365 for business. After the licenses have synced, you can view licenses information by either visiting a matched organization and choosing the Office 365 Licenses flexible asset, or by viewing a Global list of Office 365 License flexible assets. To view via an organization. Select the organization you want to view and select Office 365 Licenses on the sidebar.

Do you think it’s easy? Definitely not! Because we need to consider following things before jumping right away.

Manage Microsoft 365 Users, Licenses, And Groups with PowerShell April 21, 2021 April 21, 2021 O365 Powershell, Office 365, Office 365 Reports No Comments With Microsoft 365 admin center, you can easily manage Microsoft 365 user accounts and licenses. Microsoft 365 A1 (one-time, per device license paired with free Office 365 A1 per user licenses) Microsoft 365 A3 (includes Office 365 A3) Microsoft 365 A5 (includes Office 365 A5) U.S. Government (unlimited number of users) See all available plans. Microsoft Office 365 Product Key + Crack Activator is one of the methods. Get the official version of Office 365 License Key. The product key is free.

1. A user can have multiple licenses.
2. Each license gives access to a set of services.
3. A user might not have access to all services. Some services might be enabled or disabled based on user needs.
4. License subscription names are not user-friendly by default.

We have created a PowerShell script that will get you the detailed license usage report covering all the above cases. It reports all licensed users with their country, assigned licenses, services, and its status. So! Let’s jump into the script right away.

Download Script: O365UserLicenseReport

Script Highlights:

• Exports Office 365 user license report to CSV file.
• You can choose to either “export license report for all office 365 users” or pass an input file to get license report of specific users alone.
• License Name is shown with its friendly name like ‘Office 365 Enterprise E3’ rather than ‘ENTERPRISEPACK’.
• The script can be executed with MFA enabled account
• The script gives 2 output files. One with the detailed report of O365 Licensed users another with the simple details.
• Output file stores most required attributes like Display Name, User Principal Name, Country, Licenses, License Friendly Name, Service, Service Friendly Name, and Service Status. You can include more attributes by easily modifying the script.

Office 365 License Report – Sample Outputs:

Exported report shows list of licensed users and their assigned licenses.

Detailed Office 365 User License Report:

Detailed Office 365 users’ assigned license report contains user’s Display Name, User Principal Name, License Plan, Friendly-name of License Plan, Service Name, Friendly-name of Service, and Service Status.

Simple Office 365 User License Report:

The simple Office 365 user license report contains user’s Display Name, User Principal Name, and Friendly-name of assigned license with their respective services.

Office 365 User License Report – Execution Methods:

You can use this script to either export all licensed users or export list of licensed users in Office 365.

Export all Licensed Users in Office 365:

To export all licensed users in Office 365, run the script as follows.

Get Office 365 License Report for a Single/List of Office 365 Users:

You can use –UserNamesFile param to get license report of a user from the input list called “UserNamesInput.txt”.