Notification

Icon
Error

Exchange Mailbox Usage - Report detailing Exchange Mailbox size

Posted: Thursday, October 17, 2019 8:26:43 PM(UTC)
nhouse24

nhouse24

Member Original PosterPosts: 5
0
Like
I am looking for a report that will detail Exchange mailbox usage but also allow it to filter out mailboxes over or under a specific size.
nhouse24
#1nhouse24 Member Original PosterPosts: 5  
posted: 10/17/2019 10:31:09 PM(UTC)
I found my own solution. This code will filter out mailbox sizes over just under 1 GB.

SELECT TOP (1000000) tblExchangeMailbox.DisplayName, tblExchangeMailbox.Alias, tblExchangeMailbox.RecipientTypeDetails, addresses.email AS EmailAddress, tblExchangeServer.AssetId AS ServerAssetId,
tblExchangeServer.Name AS ExchangeServer, tblExchangeMailboxStatistics.TotalItemSize
FROM tblExchangeMailbox LEFT OUTER JOIN
(SELECT MIN(Address) AS email, MailboxId
FROM tblExchangeMailboxAddress
GROUP BY MailboxId) AS addresses ON addresses.MailboxId = tblExchangeMailbox.MailboxId INNER JOIN
tblExchangeServer ON tblExchangeServer.ServerId = tblExchangeMailbox.ServerId INNER JOIN
tblExchangeMailboxStatistics ON tblExchangeMailbox.MailboxId = tblExchangeMailboxStatistics.MailboxId
WHERE (tblExchangeMailboxStatistics.TotalBytes > 900000000)
ORDER BY tblExchangeMailboxStatistics.TotalBytes DESC

Active Discussions

Lansweeper Unable to send to External Email
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 8:21:01 PM(UTC)
Lansweeper Lansweeper assets not being Scanned
by  Jordan  
Go to last post Go to first unread
Last post: Yesterday at 6:42:22 PM(UTC)
Lansweeper Database size growing too large
by  bladd   Go to last post Go to first unread
Last post: Yesterday at 4:26:44 PM(UTC)
Lansweeper Searching Specific File
by  mzipperer  
Go to last post Go to first unread
Last post: Yesterday at 4:23:29 PM(UTC)
Lansweeper Exchange 2010 information is not populating
by  Moe   Go to last post Go to first unread
Last post: Yesterday at 12:30:38 PM(UTC)
Lansweeper Routinely Exploited Vulnerabilities Query Report
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 12:25:31 PM(UTC)
Lansweeper Creating a report for new devices every 2 hours to alert
by  Moe   Go to last post Go to first unread
Last post: 6/4/2020 7:26:11 PM(UTC)
Lansweeper Changes in the licensing model
by  BullGates  
Go to last post Go to first unread
Last post: 6/4/2020 6:27:23 PM(UTC)