→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
steve_bennett
Engaged Sweeper
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
2 REPLIES 2
steve_bennett
Engaged Sweeper
You absolute legend! thanks so much!
hrhansen
Engaged Sweeper
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