powershell- Office 365 Reports Mailbox usage limit

Welcome Forums General PowerShell Q&A powershell- Office 365 Reports Mailbox usage limit

Viewing 6 reply threads
  • Author
    Posts
    • #187480
      Participant
      Topics: 2
      Replies: 7
      Points: 44
      Rank: Member

      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

       

    • #187492
      Senior Moderator
      Topics: 8
      Replies: 1141
      Points: 3,927
      Helping Hand
      Rank: Community Hero

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

      Get-Mailbox | Select-Object -Property *Quota
      
    • #187510
      Participant
      Topics: 2
      Replies: 7
      Points: 44
      Rank: Member

      10x,

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

      🙂

       

    • #187582
      Participant
      Topics: 2
      Replies: 7
      Points: 44
      Rank: Member

      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

       

       

    • #187615
      Participant
      Topics: 23
      Replies: 160
      Points: 439
      Helping Hand
      Rank: Contributor

      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

    • #187618
      Participant
      Topics: 2
      Replies: 7
      Points: 44
      Rank: Member

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

      Thanks

       

    • #187639
      Participant
      Topics: 23
      Replies: 160
      Points: 439
      Helping Hand
      Rank: Contributor

      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

       

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

       

       

Viewing 6 reply threads
  • You must be logged in to reply to this topic.