powershell- Office 365 Reports Mailbox usage limit

PowerShell Help
1

Hi,

I wanted to know if there is any way to generate a report from our exchange online 365 of all user’s mailboxes that arrived at their 90% limit of the mailbox quota, getting some kind of alert.

Thanks

 

2

Never managed 0365 using PowerShell, but I think Get-Mailbox should get you it.

Get-Mailbox | Select-Object -Property *Quota
3

10x,

I will try this command tomorrow and let you know about the results

:slight_smile:

 

4

I’m getting this kind of results:

ArchiveWarningQuota : 90 GB (96,636,764,160 bytes)

ProhibitSendQuota : 99 GB (106,300,440,576 bytes)
ProhibitSendReceiveQuota : 100 GB (107,374,182,400 bytes)
RecoverableItemsQuota : 30 GB (32,212,254,720 bytes)
RecoverableItemsWarningQuota : 20 GB (21,474,836,480 bytes)
CalendarLoggingQuota : 6 GB (6,442,450,944 bytes)
IssueWarningQuota : 98 GB (105,226,698,752 bytes)
RulesQuota : 256 KB (262,144 bytes)
ArchiveQuota : 100 GB (107,374,182,400 bytes)
ArchiveWarningQuota : 90 GB (96,636,764,160 bytes)

ProhibitSendQuota : 99 GB (106,300,440,576 bytes)
ProhibitSendReceiveQuota : 100 GB (107,374,182,400 bytes)
RecoverableItemsQuota : 30 GB (32,212,254,720 bytes)
RecoverableItemsWarningQuota : 20 GB (21,474,836,480 bytes)
CalendarLoggingQuota : 6 GB (6,442,450,944 bytes)
IssueWarningQuota : 98 GB (105,226,698,752 bytes)
RulesQuota : 64 KB (65,536 bytes)
ArchiveQuota : 100 GB (107,374,182,400 bytes)
ArchiveWarningQuota : 90 GB (96,636,764,160 bytes)

ProhibitSendQuota : 99 GB (106,300,440,576 bytes)
ProhibitSendReceiveQuota : 100 GB (107,374,182,400 bytes)
RecoverableItemsQuota : 30 GB (32,212,254,720 bytes)
RecoverableItemsWarningQuota : 20 GB (21,474,836,480 bytes)
CalendarLoggingQuota : 6 GB (6,442,450,944 bytes)
IssueWarningQuota : 98 GB (105,226,698,752 bytes)
RulesQuota : 256 KB (262,144 bytes)
ArchiveQuota : 100 GB (107,374,182,400 bytes)
ArchiveWarningQuota : 90 GB (96,636,764,160 bytes)

ProhibitSendQuota : 99 GB (106,300,440,576 bytes)
ProhibitSendReceiveQuota : 100 GB (107,374,182,400 bytes)
RecoverableItemsQuota : 30 GB (32,212,254,720 bytes)
RecoverableItemsWarningQuota : 20 GB (21,474,836,480 bytes)
CalendarLoggingQuota : 6 GB (6,442,450,944 bytes)
IssueWarningQuota : 98 GB (105,226,698,752 bytes)
RulesQuota : 256 KB (262,144 bytes)
ArchiveQuota : 100 GB (107,374,182,400 bytes)
ArchiveWarningQuota : 90 GB (96,636,764,160 bytes)

 

is it possible to get it more detailed?

user name? email address?

Thanks

 

 

5

This will get you more information in your results, You’d need to do some other logic to trim it down to your 90% of quota.

This will retrieve every mailbox in your 365 environment.

 

Get-Mailbox -filter *| Select-Object -Property *Quota,alias,displayname

6

How can i export all the results to Excel file or an email?

Thanks

 

7

you can’t export to excel natively, there is a module available importexcel, but it’s not the easiest to deal with.

 

if you just want to see the results in a spreadsheet, the easiest is to just export to csv

 

[pre]Get-Mailbox -filter *| Select-Object -Property *Quota,alias,displayname|export-csv -notypeinformation mailbox_quota.csv[/pre]