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 NOT doesn't work as expected
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Yesterday at 5:49:29 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Leslie Stroobant  
Go to last post Go to first unread
Last post: Yesterday at 3:27:42 PM(UTC)
Lansweeper All Devices with WINS Service Running on the Network
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 2:44:56 PM(UTC)
Lansweeper Physical Laptops and Desktops Only
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 1:51:56 PM(UTC)
Lansweeper Assistance With AV & Bitlocker Report
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 12:50:47 PM(UTC)
Lansweeper Count of completed KB installation Report
by  jamie21  
Go to last post Go to first unread
Last post: 6/4/2020 11:49:57 AM(UTC)
Lansweeper local admin users of a specific device
by  Andy.S   Go to last post Go to first unread
Last post: 6/4/2020 10:42:23 AM(UTC)
Lansweeper Bitlocker Report not contain all computers
by  Andy.S  
Go to last post Go to first unread
Last post: 6/3/2020 6:20:53 PM(UTC)