Exchange mailbox widget

cwsmith181

Anybody know if you can create a dashboard with Exchange Mailbox Usage for all exchange servers? I can see the widget inside each exchange server however; it sucks to have to go into each server to see the usage. The widget doesn't show up outside of the Exchange Application Summary for each server.

ecmel

There are multiple ways to configure it.

If you would like to create a Classic Summary view, then you can add "Custom Table" widget and choose "Load Table Configuration from Report" button. In the report area, you can search for "mailbox" and choose "Users by Mailbox Size" report as shown below. This will add a custom table form an out-of-the-box report:

If you would like to use Modern Dashboard, then you can get the actual SWQL query from the same report and use it in a "Custom Table" widget. I also added the query below:

SELECT TOP 1000
    a.Name,
    a.Status as [ApplicationStatus],
    a.DetailsUrl as [ApplicationDetailsUrl],
    mb.DisplayName,
    mb.Status as [MailboxStatus],
    mb.DetailsUrl as [MailboxDetailsUrl],
    mb.Type,
    '' + mb.PrimarySmtpAddress + '' as [PrimarySmtpAddress],
    mb.TotalItemSize,
    mb.ItemCount,
    mb.AttachmentsSize,
    ToLocal(mb.LastLogonTime) as [LastLogonTime],
    mb.Database.Identity,
    mb.Database.Status as  [DatabaseStatus],
    mb.Database.DetailsUrl as [DatabaseDetailsUrl]
FROM Orion.APM.Exchange.Mailbox mb
JOIN Orion.APM.Exchange.DatabaseCopy dc ON dc.IsActive = 1 AND dc.DatabaseID = mb.DatabaseID
JOIN Orion.APM.Exchange.Application a ON a.ApplicationID = dc.ApplicationID
ORDER BY TotalItemSize DESC