exchange mailbox size report

spiceuser-sl9nn · 2019-09-04T10:15:29.000Z

Hi,

i have the report “exchange info” and am trying to get a report of current mailbox size, and max currently allowed size per user.

My exchange is talking properly to spiceworks, i get all the current mailbox size, but i don’t see the “allowed size” currently. Is there a way to see both the current size and the max size side by side to help know if the user is close to its limit?

here is the script i currently use:

--Created 3/17/09 by Ben Brookshire, Spiceworks Inc.
--Copyright Spiceworks, Inc. 2009-12
--v0.2 - added StoragePath info
--v0.3 (2/17/2010)- added ORDER BY Size
--v0.4 (9/7/2010) - convert size in graph to MB, added CASE to determine GB/MB/KB sizing
--v0.4.1 - fixed conversions to actually be GB/MB/KB
--v0.5 - add filter to remove smaller mailboxes

SELECT mb.display_name as Name,
  mb.size/(1024*1024) as "Size (MB)",
  --mb.size as "SizeOLD",
  CASE
    WHEN mb.size >= (1024.0*1024.0*1024.0) THEN round(cast(mb.size/(1024.0*1024.0*1024.0) as real),2) || " GB"
    WHEN mb.size >= (1024.0*1024.0) THEN round(cast(mb.size/(1024.0*1024.0) as real),2) || " MB"
  ELSE cast(mb.size/(1024.0) as real) || " KB"
  END as Size,
  mb.total_items as TotalItems,
  mb.last_logon as LastLogon,
  mb.storage as StoragePath,
  m.name as ExchangeServer

FROM microsoft_exchange_mailboxes mb

JOIN microsoft_exchanges m
  ON (m.computer_id = mb.computer_id)

 --WHERE (mb.size/(1024.0*1024.0)) > 50  -- filter mailboxes smaller than 50MB

ORDER BY "Size (MB)" DESC;

davidr4 · 2019-09-04T10:21:59.000Z

If you have exchange, it would be easier to just get the info straight from there via Powershell. Here is a good Mailbox Report script

https://gallery.technet.microsoft.com/scriptcenter/Generate-Mailbox-Size-and-3f408172

spiceuser-sl9nn · 2019-09-04T10:23:15.000Z

I know, but i want to program a weekly report sent by email. as far as i know this isnt possible through powershell

davidr4 · 2019-09-04T10:27:25.000Z

That is exactly what the script I sent you does. Schedule it to run as a scheduled task and it will email you a report of the mailboxes. Everything is possible with Powershell, especially in Exchange.

joz · 2019-09-05T03:57:28.000Z

Agree with davidr4‘s suggestions.

You can combine the scripts and task schedule to generate a weekly report. About configuring task schedule for your reference: Automate Mailbox Size Reporting in Office 365