Friday 31 August 2012

Get MailboxStatistics

$Results = @()

$mbx = Get-mailbox -ResultSize "Unlimited"
foreach ($mb in $mbx)
{
$Srv = New-Object PSObject
$stat = Get-mailbox $mb.Alias | Get-MailboxStatistics
$usr = Get-User $mb.Alias

$Srv | Add-Member -MemberType NoteProperty -Name UserName -Value $mb.Name
$Srv | Add-Member -MemberType NoteProperty -Name FirstName -Value $usr.FirstName
$Srv | Add-Member -MemberType NoteProperty -Name LastName -Value $usr.LastName
$Srv | Add-Member -MemberType NoteProperty -Name DisplayName -Value $stat.DisplayName
$Srv | Add-Member -MemberType NoteProperty -Name Title -Value $usr.Title
$Srv | Add-Member -MemberType NoteProperty -Name Department -Value $usr.Department
$Srv | Add-Member -MemberType NoteProperty -Name Office -Value $mb.Office
$Srv | Add-Member -MemberType NoteProperty -Name Fax -Value $usr.Fax
$Srv | Add-Member -MemberType NoteProperty -Name City -Value $usr.City
$Srv | Add-Member -MemberType NoteProperty -Name State -Value $usr.State
$Srv | Add-Member -MemberType NoteProperty -Name CountryorRegion -Value $usr.CountryorRegion
$Srv | Add-Member -MemberType NoteProperty -Name PostalCode -Value $usr.PostalCode
$Srv | Add-Member -MemberType NoteProperty -Name PrimarySmtpAddress-Value $mb.PrimarySmtpAddress
$Srv | Add-Member -MemberType NoteProperty -Name TotalItemSize -Value $stat.TotalItemSize
$Srv | Add-Member -MemberType NoteProperty -Name IssueWarningQuota -Value $mb.IssueWarningQuota
$Srv | Add-Member -MemberType NoteProperty -Name ProhibitSendQuota -Value $mb.ProhibitSendQuota
$Srv | Add-Member -MemberType NoteProperty -Name ProhibitSendReceiveQuota -Value $mb.ProhibitSendReceiveQuota
$Srv | Add-Member -MemberType NoteProperty -Name ItemCount -Value $stat.Itemcount
$Srv | Add-Member -MemberType NoteProperty -Name LastLogonTime -Value $stat.LastLogonTime
$Srv | Add-Member -MemberType NoteProperty -Name LastLogoffTime -Value $stat.LastLogoffTime
$Srv | Add-Member -MemberType NoteProperty -Name AssociatedItemCount -Value $stat.AssociatedItemCount
$Srv | Add-Member -MemberType NoteProperty -Name DeletedItemCount -Value $stat.DeletedItemCount
$Srv | Add-Member -MemberType NoteProperty -Name DisconnectDate -Value $stat.DisconnectDate
$Srv | Add-Member -MemberType NoteProperty -Name LastLoggedOnUserAccount -Value $stat.LastLoggedOnUserAccount
$Srv | Add-Member -MemberType NoteProperty -Name ObjectClass -Value $stat.ObjectClass
$Srv | Add-Member -MemberType NoteProperty -Name TotalDeletedItemSize -Value $stat.TotalDeletedItemSize
$Srv | Add-Member -MemberType NoteProperty -Name MoveHistory -Value $stat.MoveHistory
$Srv | Add-Member -MemberType NoteProperty -Name IsQuarantined -Value $stat.IsQuarantined
$Srv | Add-Member -MemberType NoteProperty -Name IsArchiveMailbox -Value $stat.IsArchiveMailbox
$Srv | Add-Member -MemberType NoteProperty -Name IsMoveDestination -Value $stat.IsMoveDestination



$Results += $Srv
}
$Results  | Export-CSV "C:\Result18.csv" -notype

No comments:

Post a Comment