[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Subscription count by country in PowerShell

Posted on 2012-09-03
Medium Priority
Last Modified: 2012-09-07

This is my first question at Experts Exchange. Please let me know if I am missing something vital in my question. Thank you!

Our company uses Office 365 for our callaborations needs (E-mail, Lync and SharePoint).
The parent company has 8 child-companies which we need to bill each month for the Office 365 licenses being used in each child-company. One legal company per country.

How may I, using PowerShell or another tool, get the amount of different licences being used in Office 365 grouped by country?
Counting manually each month is not an option as it is too many accounts.

Example output
Country       {company:CRMSTANDARD}   {company:ENTERPRISEPACK}
Sweden       2                                                      78
Norway       1                                                      4
Germany     4                                                     120
France         3                                                      55

Thank you for your help!
Question by:jeliasson
  • 2

Expert Comment

ID: 38361118

Author Comment

ID: 38361693
Sorry, but that's abit to lightweight to the result/output I'm trying to achieve.
LVL 44

Accepted Solution

Vasil Michev (MVP) earned 1200 total points
ID: 38375350
You can extract the data using PowerShell, but managing it there is a bit complicated.

Here is my suggestion:

Download the Office 365 Helper Scripts from: http://www.microsoft.com/en-us/download/details.aspx?id=29568

Run the GetMsolUserReport.ps1 to get the needed data

Open the generated csv file in Excel and make a Pivot Table to group the data as per your preference. For example, UPN for the Report filter, AssignedLicenses for Column Labels, UsageLocation for Row Labels and Count of Assigned licenses for Values

You might consider filtering the unlicensed users first, as the script will return all users in your tenant

Author Closing Comment

ID: 38376776
Thank you for your help!

Featured Post

New Tabletop Appliances Blow Competitors Away!

WatchGuard’s new T15, T35 and T55 tabletop UTMs provide the highest-performing security inspection in their class, allowing users at small offices, home offices and distributed enterprises to experience blazing-fast Internet speeds without sacrificing enterprise-grade security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Measuring Server's processing rate with a simple powershell command. The differences in processing rate also was recorded in different use-cases, when a server in free and busy states.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Loops Section Overview

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question