updated: 8/11/2016 (created heders/CSV logic)

Updated: 8/15/2016 (fixed service status when m,ultiple licenses are there)      

Updated: 7/4/2017 (fixed when users has e3 as well as e5 - multiple subscriptions)


Lately working on office 365 exchanage online, fedration & other stuff so created this script for checking the Service usage across users.

This script is still evolving but does a prety good job on services part, below is the sample result that is available after script is executed.

 

Prerequisites:

Install Microsoft Online Services Sign-In Assistant for IT Professionals 32 bit/64 bit both are available when you will browse the link.

Install Microsoft Online Services Module for Windows PowerShell 32 bit/64 bit both are available when you will browse the link.

Refer:

https://msexchange.me/2015/04/30/connecting-office-365-via-powershell/

Ones you are setup, connect to Connect-MsolService, enter your office 365 admin  credentials.

Change directory in the shell to where you have kept this downloaded script.

type .\Get-Office365UsersServiceUasgeReportv1 & press enter to execute.

Script will start processing the results in csv file.

 

Resulting CSV will be in same folder:

Let me know if you want to add more information in the report.

 

 

PowerShell
Edit|Remove
############################## 
Updated:10/8/2016 
Fixed if multiple licenses are assigned to the user 
 
#######################
Regards
Sukhija Vikas
http://msexchange.me