PS - Get-MailboxStatistics, Get-Mailbox, SELECT DisplayName,ItemCount,TotalItemSize
Print
Created by: Carlos Zayas
Modified on: Fri, 30 Jun, 2017 at 6:18 PM
Create Table #Temp1( DisplayName Nvarchar(256), ItemCount Bigint,TotalItemSize Bigint)
Insert into #Temp1(DisplayName,ItemCount,TotalItemSize)
SELECT DisplayName,ItemCount,TotalItemSize
FROM OpenExchangePSQuery(
POWERSHELL, '
Get-Mailbox | Get-MailboxStatistics | Sort-Object totalitemsize -desc | Select DisplayName,ItemCount, TotalItemSize
', POWERSHELL
)
Select DisplayName,ItemCount,dbo.MB(TotalItemSize/1024) as 'total item size (GB)'
From #Temp1
Carlos is the author of this solution article.
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.
