Measure Office 365 Usage PowerShell

Measure Office 365 Usage

Hello,

If like a lot of companies you migrated over Office 365, you may want to check if you did the right thing. You can have an hint by measuring your usage in some Office 365 services.

Measure Office 365 Usage – Exchange Online

To measure the usage of Exchange Online, first, you need to connect to Exchange Online from PowerShell:

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential (Get-Credential) -Authentication Basic –AllowRedirection
Import-PSSession $Session

Then run the following line :

Get-Mailbox -ResultSize unlimited | Get-MailboxStatistics | select DisplayName,@{Label='TotalSizeInMB';Expression={(($_.TotalItemSize.Value.ToString().split('(')[-1]).split(' ')[0]).Replace(',','') /1MB -as [int]}} | Measure-Object -Property TotalSizeInMB -Sum -Average -Maximum -Minimum

This will give you the total size, average size, minimum and maximum of all your mailboxes in MB:

Measure Office 365 Usage - Exchange Online

Measure Office 365 Usage – Exchange Online

Measure Office 365 Usage – Skype Online

To measure Skype Online usage, you still need your PowerShell connected to Exchange Online. To measure the active users by type of use, you can run :

Get-CsActiveUserReport -ReportType week | Sort-Object -Property Date -Descending | Select-Object -First 1 -Property *Users*
Measure Office 365 Usage Skype Online

Measure Office 365 Usage Skype Online

You can also measure the number of each conference type usage:

Get-CsConferenceReport -ReportType week | Sort-Object -Property Date -Descending | Select-Object -First 1 -Property *Conf*
Measure Office 365 - Usage Skype Online

Measure Office 365 – Usage Skype Online

Measure Office 365 Usage – SharePoint Online/OneDrive

To measure SharePoint usage, you need also need you PowerShell connected to Exchange Online.

Run the following line:

Get-SPOTeamSiteStorageReport | Sort-Object -Property Date -Descending | Select-Object -First 1 -ExpandProperty Used

This will give you the size in MB of all your SharePoint sites:

Measure Office 365 Usage - SharePoint Online

Measure Office 365 Usage – SharePoint Online

You can also see the same statistics about the personal sites sizes:

Get-SPOSkyDriveProStorageReport | Sort-Object -Property Date -Descending | Select-Object -First 1 -ExpandProperty Used
Measure Office 365 Usage - OneDrive

Measure Office 365 Usage – OneDrive

Measure Office 365 Usage – Web Admin Portal

Or you can use the new web admin portal, but where is the fun is that ?

Measure Office 365 Usage - GUI

Measure Office 365 – GUI

Thanks to those few PowerShell lines, you may be able to build your own report to send by mail to your key users and managers. You can also use those numbers to calculate if Office 365 is cheaper than your old on premise servers.

0 thoughts on “Measure Office 365 Usage PowerShell

  1. I would like to know how I can see more reports in OneDrive sites, is it possible so get for example, see the amount of shared document internally and externally.
    But i can´t find the cmdlets for that.
    Do you know anything about that?
    Would be really helpful!

Leave a Reply