SELECT MailboxServer,DisplayName,EMailAddress,DeviceModel,DeviceID,DeviceFriendlyName,DeviceOS,LastSuccessSync
FROM OpenExchangePSQuery(
POWERSHELL, '
$mbxs = Get-CASMailBox -ResultSize Unlimited -Filter {HasActiveSyncDevicePartnership -eq $true -and -not DisplayName -like 'CAS_{*'}
foreach ($mbx in $mbxs)
{
$name = $mbx.DisplayName
$mail = $mbx.PrimarySmtpAddress
$MailboxServer = $mbx.ServerName
$stats = Get-ActiveSyncDeviceStatistics -Mailbox $mbx.Identity
foreach ($stat in $stats)
{
$Result = New-Object PSObject -Property @{
DisplayName = $name
EMailAddress = $mail
DeviceModel = $stat.DeviceType
DeviceID = $stat.DeviceID
DeviceFriendlyName = $stat.DeviceFriendlyName
DeviceOS = $stat.DeviceOS
LastSuccessSync = $stat.LastSuccessSync
MailboxServer = $MailboxServer
}
$Result | Select DisplayName,EMailAddress,DeviceModel,DeviceID,DeviceFriendlyName,DeviceOS,LastSuccessSync,MailboxServer
#$stat | fl
}
}
', POWERSHELL
)