SELECT DisplayName,ItemCount,TotalItemSize
FROM OpenExchangePSQuery(
POWERSHELL, '
$data = Get-Mailbox -Archive | Get-MailboxStatistics -Archive;
foreach ($d in $data)
{
Try
{
$totalItemSize = [long]($d.TotalItemSize.ToString().Split('(')[1].Split(' ')[0].Replace(',',''));
}
Catch
{
$totalItemSize = 0;
}
$Result = New-Object PSObject -Property @{
DisplayName = $d.DisplayName
ItemCount = $d.ItemCount
TotalItemSize = $totalItemSize
}
$Result
# Select DisplayName,ItemCount,TotalItemSize
}
', POWERSHELL
)