How to List Office 365 Subscriptions Using PowerShell

Subscriptions in Office 365 define the features and services available and how many licenses you have available to issue to user accounts. Each subscription has its own Account SKU ID such as ENTERPRISEPREMIUM for E3 subscriptions.

When you reference a subscription ID in PowerShell you will need to prefix it with your 365 tenant name. This is the part before your onmicrosoft.com address you chose when creating your account. Our test lab was created as office365laba.onmicrosoft.com so office365laba is our tenant name.

List Subscriptions

To return a list of available subscriptions and the number of licenses in your tenant run the following command:


PowerShell Managing Subscriptions 1

If you want to return a more detailed list, you can add | FL to the command which will show all attributes associated with a returned object in a formatted list (FL).

Get-MsolAccountSku | FL

PowerShell Managing Subscriptions 2


Making use of PowerShell with Office 365 gives us lots of scripting possibilities.

Top Tip!

Use these cmdlet’s┬áto write a script which alerts you when you have too many or not enough licenses.

[email-download download_id=”9941″ contact_form_id=”9351″]

If you want to learn more then you can buy my book from Amazon, either the paper back or kindle version. My advice is to buy the paperback version so you can keep it on your desk for easy reference!

Office 365 PowerShell Book

For paperback version click here

For Kindle version click here




Author: Ian@SlashAdmin

Share This Post On
468 ad


  1. Hello

    I would like to know if it is possible by powershell to see if a user is licensed (true/false).
    Then if true wouldn’t it be nice to know which type of licence the user has assigned ?

    Post a Reply
  2. Get-MsolUser -All | where {$_.isLicensed -eq $true}

    Post a Reply
    • Nice one Ed! Completely missed the original comment. Many thanks for sharing.

      Post a Reply
  3. Great article! I was wondering if there is a script that shows which users are assigned to the particular subscription ID?

    Post a Reply
  4. Is it possible, if we can get the license expiration date using any script or command.

    Post a Reply

Leave a Reply to Jason Tremper Cancel reply

Your email address will not be published.