Mailbox Size Report

[steve_bennett]

Morning all,

I am aware of the widget that displays the top X mailboxes based on size, but does anyone have a report that would report on all mailbox sizes?

Regards

[steve_bennett]

You absolute legend! thanks so much!

[hrhansen]

Like this:

Select Top 1000000 'globe-green.png' As Icon,
tblExchangeMailbox.DisplayName,
tblExchangeMailbox.Alias,
tblExchangeMailbox.RecipientType,
tblExchangeMailbox.RecipientTypeDetails,
addresses.email As EmailAddress,
tblExchangeServer.AssetId As ServerAssetId,
tblExchangeServer.Name As ExchangeServer,
tblExchangeMailboxStatistics.TotalItemSize
From tblExchangeMailbox
Left Outer Join (Select Min(tblExchangeMailboxAddress.Address) As email,
tblExchangeMailboxAddress.MailboxId
From tblExchangeMailboxAddress
Group By tblExchangeMailboxAddress.MailboxId) addresses On
addresses.MailboxId = tblExchangeMailbox.MailboxId
Inner Join tblExchangeServer On tblExchangeServer.ServerId =
tblExchangeMailbox.ServerId
Inner Join tblExchangeMailboxStatistics On tblExchangeMailbox.MailboxId =
tblExchangeMailboxStatistics.MailboxId
Order By tblExchangeMailbox.DisplayName