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 – 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

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 – 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

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 – Web Admin Portal

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

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.