Office 365 Users Service Usage Report

Lately working on office 365 exchange online, federation & 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. (download from below link)

https://gallery.technet.microsoft.com/scriptcenter/Office-365-Users-Service-dcbd618b

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.

############################################################### 
#            Author: Vikas Sukhija (http://msexchange.me) 
#            Date: 8/4/2016 
#            Reviewer: 
#            updated: 8/11/2016 (created heders/CSV logic) 
#            Updated: 8/15/2016 (fixed service status when m,ultiple licenses are there) 
#            Description: Office 365 users Report 
# 
############################################################### 
 
$collection = @() 
 
$output = new-item .\office365report.csv -type file -force 
 
$lict = Get-MsolAccountSku 
$services = $lict.ServiceStatus 
 
$csv = @() 
$csv1=$null 
 
foreach($service in $services){ 
$provisionstatus = $service.ProvisioningStatus 
$servicename = $service.ServicePlan.ServiceName 
$csv +$servicename} 
 
$expcsv=$csv | sort -Unique 
 
$countcs$expcsv.count 
 
foreach($cs in $expcsv){$csv1 += [string]$cs + ","} 
 
$csv2 = $csv1.Substring(0,$csv1.Length-1) 
 
add-content $output "FirstName,LastName,ImmutableId,SignInName,UserPrincipalName,License,$csv2" 
 
##################GEt values from users##################### 
 
$allusers = get-msoluser -all 
 
foreach($user in $allusers){ 
 
$FirstName = $user.FirstName 
$LastName = $user.LastName 
$signInname = $user.SignInName 
$UserPrincipalName = $user.UserPrincipalName 
 
Write-host "Processing..................$UserPrincipalName" -foregroundcolor green 
 
$ImmutableId=$user.ImmutableId 
$licenses = $user.Licenses.AccountSkuId 
$license=$null 
if($licenses -notlike $null){ 
foreach($lic in $licenses){$license +$lic + ","$license$license.Substring(0,$license.Length-1)} 
 
$serviceplan = $user.Licenses.ServiceStatus.serviceplan 
$provsts = $user.Licenses.ServiceStatus.provisioningstatus 
$spcount = $serviceplan.count 
 
[int]$spcount1=$spcount -1 
[int]$countcs1=$countcs -1 
 
################Compare the Header with Values################ 
 
$provval1=@(0..[int]$countcs1for($j=0;$j -le [int]$countcs1;$j++){$provval1[$j]="not found"} 
 
 
for($i=0;$i -le [int]$spcount1;$i++){ 
    for($j=0;$j -le [int]$countcs1;$j++){ 
    if($serviceplan[$i].serviceName -eq $expcsv[$j]){ 
    $provval1[$j] = [string]$provsts[$i]} } 
} 
 
$prov=$null 
for($j=0;$j -le [int]$countcs1;$j++){ 
$prov += [string]$provval1[$j+ ","} 
 
$prov1$prov.Substring(0,$prov.Length-1) 
 
#####################License values####################################### 
 
switch -Wildcard ($license){ 
    "*DESKLESSPACK*" {$licensevalue="Office 365 (Plan K1)"}  
        "*DESKLESSWOFFPACK*" {$licensevalue="Office 365 (Plan K2)"}  
        "*LITEPACK*" {$licensevalue="Office 365 (Plan P1)"}  
        "*EXCHANGESTANDARD*" {$licensevalue="Office 365 Exchange Online Only"}  
        "*STANDARDPACK*" {$licensevalue="Office 365 (Plan E1)"}  
        "*ENTERPRISEPACK*" {$licensevalue="Office 365 (Plan E3)"}  
        "*ENTERPRISEPACKLRG*" {$licensevalue="Office 365 (Plan E3)"} 
        "*ENTERPRISEWITHSCAL*" {$licensevalue="Office 365 (Plan E4)"} 
        "*STANDARDPACK_STUDENT*" {$licensevalue="Office 365 (Plan A1) for Students"} 
    "*ENTERPRISEPACK_STUDENT*" {$licensevalue="Office 365 (Plan A3) for Students"} 
    "*ENTERPRISEWITHSCAL_STUDENT*" {$licensevalue="Office 365 (Plan A4) for Students"} 
    "*STANDARDPACK_FACULTY*" {$licensevalue="Office 365 (Plan A1) for Faculty"} 
    "*STANDARDWOFFPACKPACK_FACULTY*" {$licensevalue="Office 365 (Plan A2) for Faculty"} 
    "*ENTERPRISEPACK_FACULTY*" {$licensevalue="Office 365 (Plan A1) for Students"} 
    "*STANDARDPACK_STUDENT*" {$licensevalue="Office 365 (Plan A1) for Students"}     
    "*ENTERPRISEPACK_FACULTY*" {$licensevalue="Office 365 (Plan A3) for Faculty"} 
    "*ENTERPRISEWITHSCAL_FACULTY*"{$licensevalue="Office 365 (Plan A4) for Faculty"} 
    "*ENTERPRISEPACK_B_PILOT*" {$licensevalue="Office 365 (Enterprise Preview)"} 
    "*STANDARD_B_PILOT*" {$licensevalue="Office 365 (Small Business Preview)"} 
        default {$licensevalue="not found"} 
} 
 
add-content $output "$FirstName,$LastName,$ImmutableId,$signInname,$UserPrincipalName,$licensevalue,$prov1" 
 
 
} 
######################################
Regards
Sukhija Vikas
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s