Differences

This shows you the differences between two versions of the page.

--- windows_wiki:powershell_office_365 [2015/03/05 13:34]
psycardis
+++ windows_wiki:powershell_office_365 [2017/03/20 16:31]
psycardis added option to export usermailbox size to csv
@@ Line 1: / Line 1: @@
-=== Overview ===
+====== Powershell Office 365 ======
+**General Information**
 This Wiki will provide a basic overview of common commands to be used for office 365 power shell work. Copy and past all commands in a given section as they are seen in bold. Make sure you run all commands in power shell, and that you launch it as an administrator.
@@ Line 5: / Line 7: @@
 As I work with power shell I will add commands in here.
+**Checklist**
+  * Powershell CLI installed
+----
 == Connecting Office 365 Exchange Power Shell Session (do this before anything below) ==
@@ Line 113: / Line 119: @@
 '''Get-MSOLUser | Set-MsolUser -PasswordNeverExpires $true'''
+==== Get List of Mailboxes Sorted by Size ====
+''Get-Mailbox | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount''
+Or to export to CSV:
+Get-Mailbox | Get-MailboxStatistics | Sort totalitemsize -desc | select-object displayname, totalitemsize, itemcount | Export-Csv -notype "C:\temp\UserMailboxSize.csv"