How To: Report on "Consumed Portal Licenses"
Modified on Wed, 11 Jan 2023 at 05:04 PM
- CoreView Release Notes March 2023
- CoreView Release Notes February 2023
- CoreView Release Notes January 2023
- CoreView December 2022 Release Notes
- CoreView November 2022 Release Notes
- CoreView October 2022 Release Notes
- September 2022 Release Notes
- August 2022 Release Notes
- Release 22.06 Key Features
- Release 22.05 Key Features
- Release 22.04 Key Features
- Release 22.03 Key Features
- Release 22.01 Key Features
- Release 21.12 Key Features
- Release 21.11 Key Features
- Release 21.10 Key Features
- Release 21.09 Key Features
- Release 21.08 Key Features
- Release 21.07 Key Features
- Release 21.05 Key Features
- Release 21.04 Key Features
- Release 21.03 Key Features
- Release 21.02 Key Features
- Release 21.01 Key Features
- Release 20.12 Key Features
- Release 20.11 Key Features
- Release 20.10 Key Features
- Release 20.09 Key Features
- Release 20.08: Key Features:
- Release 20.07: Key Features:
- Release Information
- Getting Started with Customer Care
Getting Started with CoreView
- Configuration Overview (New UX)
- Configuration Overview
- Creating CoreView Tenant Administrators (New UX)
- Creating CoreView Tenant Administrators
- CoreView Operator Uses Cases & Dependencies
- Creating a License Pool
- Understanding Virtual Tenants
- Frequently Asked Configuration Questions
- "Send As" DNS Requirements for CoreAdoption Campaigns (Optional)
- How to enforce MFA on CoreView service accounts
- Creating a License Pool
A Quick Tour of CoreView
- A Quick Tour of the CoreView Interface
- Introducing the CoreView New User Experience
- CoreView New UX FAQ
- CoreView Dashboards
- Using CoreView Reports
- How to use CoreView Management Actions (New UX)
- How to use CoreView Management Actions
- Understanding CoreView Releases
- Creating your first Workflow - A Practical Exercise
- How to check and analyze the Message Trace
- How To Configure Email Forwarding
- How to convert a user mailbox to a shared mailbox in Exchange Online
- How to Create Microsoft 365 Groups for Improved Collaboration
- How To Create Shared Mailbox
- How To Create User Mailbox
- How To Grant Access To Mailbox
- How to review and manage Exchange online mailbox permissions
- How to verify if a user has updated the Password
- Read Permission for Mailbox
- What are security groups and How to create it
- What is a Distribution Group and How to create it
- Exchange Online
- Custom Actions Library
- Getting Started with CoreHybrid
Understanding CoreView - Quick Start Guides.
- CoreView Quick Start Guide Overview and Index - Tenant Admins
- CoreView Quick Start Guide Overview and Index - Operators
- Understanding CoreView Tenant Configuration – Management
- Understanding the CoreView Operator Profile
- Understanding CoreView Operator Roles
- Understanding CoreView Operator Delegation
- Understanding CoreView - Report Column Filtering
- Understanding CoreView - The User Interface
- Understanding CoreView Tenant Configuration - V-Tenant User Filters
- Understanding CoreAdoption – Templates and Campaigns
- Understanding CoreLearning - Content Hierarchy
- Understanding CoreView Tenant Configuration - Portal Information
- Understanding CoreView Tenant Configuration - CoreLearning
- Understanding CoreView Tenant Configuration Options
Troubleshooting Common Issues
- Unable to see OneDrive, SharePoint and Exchange Data (New UX)
- Unable to see OneDrive, SharePoint and Exchange Data
- Remote Office 365 PowerShell session can Conflict CoreView Management Actions
- Why I cannot save the changes on existing License pool?
- Error when attempting to perform a Management Action (New UX)
- Error when attempting to perform a Management Action
- Unable to modify the Assigned Licenses in my License Pool Report
- Enabling Permission for Endpoint Manager Actions (New UX)
- Enabling Permission for Endpoint Manager Actions
- How to enable permission for BitLocker keys report (New UX)
- How to enable permission for BitLocker keys report
- How to recreate Admins Read-only (New UX)
- How to recreate Admins Read-only
- How to add an operator to the portal?
- How to enable and configure CoreView management session (New UX)
- How to enable and configure CoreView management session Current UX
- How to provide a consent to activate Azure AD Reports Feature and activate Partial Import?
- Tips & Tricks: Leverage Pivot Reports to Prototype License Pool Criteria Filter
- Tips & Tricks - How to manage email notifications for newly added Operators.
- Disable MFA from Read Only Service Accounts
- How To: Report on "Consumed Portal Licenses" (New UX)
- How To: Report on "Consumed Portal Licenses"
- How to Configure Allowed IP Addresses for CoreView Service Accounts
- Tips & Tricks: How to merge License Pools
- How to Use CoreView's Global Report Filters
- How to use the What If tool to check Azure AD conditional access policies
- How to Configure Allowed IP Addresses for CoreView Service Accounts
- How to Archive a Teams Group
- How to Restore a Teams Group
- On-demand Import for a Single Device in Endpoint Manager (Intune)
- Custom Actions using the Microsoft Graph API
- How to set up your tenant for the switch to Microsoft Graph API
- GraphAPI configuration: How to get Client ID and Client Secret
Reporting and Analytics
- How do I Check and Manage Calendar Permissions for a User? (newUX)
- How CoreView can help you with your Microsoft 365 Chargeback Goals.
- New UX: Understanding the new License Centers
- Understanding the Savings Opportunities Dashboard
- Understanding the License Optimization center
- Understanding License Pool Snapshots report
- Understanding Call quality dashboard
- Understanding Call quality report
- Understanding User call quality report
- Understanding Teams groups activity report
- Understanding Teams Adoption Growth Report
- Understanding Endpoint Manager reports
- Understanding Teams dashboard
- Understanding Risky Users report
- Understanding KPI dashboard
- Understanding Storage Dashboard
- Troubleshoot Active Users (License Usage) data
- Legacy Protocol Management
- Report Columns: Is active 30/60/90
- Quarantined Messages Report - Understanding The Reports
Managing and Administration
- Teams Voice: Direct Routing Support
- How to enable management function?
- CoreView Playbooks Overview
- CoreView Playbook Policy Overview
- Forward SMTP Address vs Forward Address management actions
- How to add the users in bulk while executing Users management actions?
- How to Create & Manage Custom Actions (New UX)
- How to Create & Manage Custom Actions
- How to schedule a report to be sent automatically, and how to modify its scheduling options?
- How to schedule an alert report for the License Count
- Tips & Tricks – How to read and modify license pool report?
- Overview of CoreView Workflow
- How to delegate Workflow management using roles
- How to configure CoreView and ServiceNow integration
- How to Enable Multi Factor Authentication for Operators and Admins who Access the CoreView Portal (New UX)
- How to Enable Multi Factor Authentication for Operators and Admins who Access the CoreView Portal
- How Can I Migrate from Group-Based Licenses to Direct Licenses Managed by CoreView?
- Naming convention rules
- Custom Actions: Forbidden and Warning Values
- How to add users to Distribution Group in bulk using via CSV
- Not able to manage licenses error (New UX)
- Not able to manage licenses error
- Using custom action json output as an input in the workflow
- Setting the Sensitivity Label on SharePoint as a Mandatory Field
- DistinguishedName vs OnPremisesDistinguishedName
Customer Engineering Workshop
- New UX Workshop - General Overview Session 2
- New UX Workshop - General Overview Session 1
- What’s new in License reporting – the new user interface and the License Center
- CoreView and ServiceNow – Integrating Workflows with ServiceNow
- Advanced Workflows & Custom Actions
- Customer Engineering Workshop: Reports, Dashboards, and Alerts
- Limiting M365 Admin Access with Permission Roles, V-tenants, and License Pools
- Customer Engineering Workshop Global - Group Licensing with CoreView
- Customer Engineering Workshop Global - Filters and Custom Actions
- Understanding CoreView - Quick Start Guides.
- Internal Customer Care Resources
- Service Issues
CoreView Product Manual
- KPI Dashboard
- Operational Reports
- License Reports
- User Reports
- Mail Traffic Reports
- Exchange Reports
- Skype for Business Reports
- Teams Reports
- Group Reports
- Device Reports
- Endpoint Manager Reports
- Security reports
- SharePoint Reports
- Aggregation Reports
- OneDrive Reports
- Yammer Reports
- Report Actions
- Getting Started with CoreLearning
- Getting Started with CoreScan
- Getting Started with CoreTag
- Getting Started with CoreSaaS
- Learning Platform
This article covers how to gather data on the accounts and number of consumed portal licenses within your tenant.
From time to time, customers ask how they can review the accounts associated with the number of Consumed Portal Licenses reported in the ‘Portal information’ tab in the ‘My organization’ settings. This article shows you how to verify that number, in various ways using CoreView.
Definition of ‘Consumed portal licenses’
Note: The count of "Consumed" portal licenses represents the set of all distinct user or mailbox accounts to which there is at least one Microsoft 365 license assigned to any account.
Please note the following conditions for Consumed portal licenses:
- Count Update: The official Consumed Portal License count is updated at the conclusion of a Full Import, so roughly every twenty-four (24) hours.
- Microsoft Applied Licenses: These are licenses that Microsoft may have added to your tenant that you have not purchased. Some may be trial versions and other new capabilities.
- Free Licenses: CoreView will count the assignment of free licenses, such as ToDo, or Flow, as a valid license.
- Expired Subscriptions: Administrators should be timely in removing from users any license associated with an expired Microsoft subscription to avoid an expired license from being included in the Consumed Portal License count. CoreView does not remove licenses from users when a subscription expires if they remain in the Office 365 tenant.
How to check your ‘Consumed portal licenses’ using Microsoft PowerShell
To view the list of all user accounts in your organization that have been assigned any of your licensing plans (licensed users / Consumed portal licenses), run the following command:
Connect-Graph -Scopes User.Read.All, Organization.Read.All Get-MgUser -Filter 'assignedLicenses/$count ne 0' -ConsistencyLevel eventual -CountVariable licensedUserCount -All -Select UserPrincipalName,DisplayName,AssignedLicenses | Format-Table -Property UserPrincipalName,DisplayName,AssignedLicenses Write-Host "Found $licensedUserCount licensed accounts."
You will get the complete list of users with assigned licenses and the total number of licensed users at the very end.
For more information or other ways to retrieve this info from Microsoft please check this article.
How to check your ‘Consumed portal licenses’ using CoreView
To produce a report of accounts associated with the Consumed Portal Licenses count you can leverage the ‘Active users’ report.
Before proceeding, make sure that you do not have any filter(s) in place (Virtual-tenants, advanced filters, …) that may otherwise limit your ability to report on the entire population of your Office 365 tenant.
Follow these steps to generate the report:
- Navigate to ‘Reports’ > ‘Users’
- Proceed by editing the columns shown in the report with the properties:
- Login name (UPN)
- Enabled friendly service plans
- To show only the users counted as ‘Consumed portal licenses’, you’ll need to apply a filter.
- In the ‘Enabled friendly service plans’ column click on the filter icon, and select ‘IsNotEmpty’ from the dropdown that appears. This will then filter out any account with no Office 365 licenses assigned.
- The accounts displayed are all the accounts that are counted as ‘Consumed portal licenses’. You can quickly validate this by scrolling down to the bottom of the display and look for the the value of ‘Items’. This number should match the number found on ‘Portal information’, illustrated above.
If you find that the number does not match what is listed on the ‘Portal information’, then please double check and make sure that there is no other filtering in place that might be constraining your results. If you still find a discrepancy, then please open a Support Case at http://support.coreview.com.
Depending on your reporting needs, you can add any additional attributes that will help you with your analysis. You can also export this data for analysis using Excel.
Tip: Analyze exported data in Excel
If you want to drill into this data a bit deeper, export the ‘Login name’ list to Excel and then run the ‘Text to Columns’ feature on the Services column to place each service into its own column.
Once you do that, you can then run create a Pivot against this data.
If you add the Services as Rows and the UPN as a value, you'll get a count of who has what.