Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

Get Office 365 Report – Mailbox Size, Last Logon Time, Licence, Archive

Posted on February 23, 2021 By rich No Comments on Get Office 365 Report – Mailbox Size, Last Logon Time, Licence, Archive

This powershell script provides information about Exchange Online mailboxes. It includes following attributes: FirstName, LastName, DisplayName, Alias, UserPrincipalName, Office, Department, TotalItemSize, LastLogonTime, RecipientTypeDetails and basic licensing information.

Script combines Get-MsolUser, Get-Mailbox and Get-MailboxStatistics cmdlets into single one. You must have appropriate permissions in your tenant to run these cmdlets.

Discovery Mailboxes are excluded from report. TotalItemSize values are converted to MB.

Windows Azure Active Directory Module for Windows PowerShell is required. Otherwise Get-MsolUser and whole script will fail.

Download O365Report.ps1, open PowerShell, navigate to folder where script was downloaded, run the script. You will get credentials popup to connect to your tenant (make sure that you use the same account to access Office 365 Admin Portal and Exchange Online). Results will be exported to CSV file.

Download

Post navigation

❮ Previous Post: Allow Domain Users to install their own printers
Next Post: Office 365: Configuring Malware Filters ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown