In the admin center, go to the Reports > Usage page.. From the Select a report drop-down, select Office 365 > Activations.. You can get a view into your organization's Office activations by looking at the Activations and Users charts. The UserNamesFile must follow the format below: UPN separated by new line without header. For each service, user’s name, License, service and its status get stored in the hash table. In the Reports pane, select the options you want, and then save your changes. That user will still be included in the Activity chart totals (see number 1) for the periods she was active in, but will not appear in the User Details table (see number 2).
As an Office 365 Administrator, often you are in the situation to get all licensed users with their assigned licenses and services. Using PowerShell commands, you can get O365 licensed users and export report to CSV file. Exported report shows list of licensed users and their assigned licenses. You can use –UserNamesFile param to get license report of a user from the input list called “UserNamesInput.txt”. It enables you to drill in to individual product level reports to give you more granular insight about the activities within each product. This report could be useful in helping you identify users that might need additional help and support to activate their Office subscription. Exports Office 365 user license report to CSV file.

To see who is licensed, unlicensed, or guest, in the admin center, go to the Users > Active users page. To export all licensed users in Office 365, run the script as follows. You must be a global administrator, global reader or reports reader in Microsoft 365 or an Exchange, SharePoint, Teams Service, Teams Communications, or Skype for Business administrator to see reports. Because we need to consider following things before jumping right away. 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. It reduces the risk to your business. If you do not have it already, please install by executing the below command-let in PowerShell. Let’s jump into the script right away. Set output file to store the result. A user might not have access to all services. If the friendly name is not found in the hash table, the original name is used. Data won't exist for all reporting periods right away. One with the detailed O365 licensed user report another with the simple Office 365 license report. The Microsoft 365 Reports dashboard shows you the activity overview across the products in your organization. ".\DetailedO365UserLicenseReport_$((Get-Date -format yyyy-MMM-dd-ddd` hh-mm` tt).ToString()).csv", ".\SimpleO365UserLicenseReport_$((Get-Date -format yyyy-MMM-dd-ddd` hh-mm` tt).ToString()).csv", "Detailed report available in: $ExportCSV", "Simple report available in: $ExportSimpleCSV", Export Office 365 License Expiry Date Report to CSV using PowerShell, Export Office 365 Users’ Logon History Report to CSV Using PowerShell, Export Office 365 Mail Traffic Report with PowerShell, Export Office 365 Mailbox Permissions Report to CSV, Export Office 365 Users' Real Last Logon Time Report to CSV, KnockKnock attack targets Office 365 corporate email accounts - It's…, New Office 365 Phishing Technique Which You Would …, Office 365 subscription expiry date report.

Each license gives access to a set of services. You can easily see how people in your business are using Microsoft 365 services. Detailed Office 365 users’ assigned license report contains user’s display name, upn, license plan, friendly name of license plan, service name, friendly name of service, and service status. You can't generate a report where you enter a user's account and then get a list which services they are using and how much. Interpret the Office activations report. For example, you can identify who is using a service a lot and reaching quotas, or who may not need an Microsoft 365 license at all. You can get a view into your organization's Office activations by looking at the Activations and Users charts. Whenever you close a user's account, Microsoft will delete that user's usage data within 30 days. Well you have come to the right place! Please refer the blog. We need to convert them to comprehensible format.

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.

You can easily see how people in your business are using Microsoft 365 services. Script execution steps available in our  O365 users’ last logon time blog. Note:You can use this script to either export all licensed users or export list of licensed users in Office 365. The table shows you a breakdown of Office activations at the user level.
The Office Activation report gives you a view of which users have activated their Office subscription on at least one device.

It'll take a few minutes for these changes to take effect on the reports in the reports dashboard. New Office 365 Phishing Technique Which You Would Fall For! To see how many licenses you have assigned and unassigned, in the admin center, go to the Billing > Licenses page. Data won't exist for all reporting periods right away.