Brian Desmond’s blog has an excellent tip on how to create an ActiveSync Device Report. I’ve been looking for a way to do this and hacked together a long powershell command and then found his tip via my feedreader. I’m going to include it here in case the permalink changes but credit goes to Brian Desmond for posting it. Thanks Brian!
Exchange 2007
$devices = @()
$mailboxes = Get-CASMailbox -ResultSize:Unlimited | Where-Object {$_.HasActiveSyncDevicePartnership -eq $true -and $_.ExchangeVersion.ExchangeBuild -ilike "8*"}
foreach ($m in $mailboxes)
{
$devices += Get-ActiveSyncDeviceStatistics -Mailbox $m.Identity
}
$devices | Export-Csv DeviceStats.csv
Exchange 2010
$devices = @()
$mailboxes = Get-CASMailbox -ResultSize:Unlimited | Where-Object {$_.HasActiveSyncDevicePartnership -eq $true -and $_.ExchangeVersion.ExchangeBuild -ilike "14*"}
foreach ($m in $mailboxes)
{
$devices += Get-ActiveSyncDeviceStatistics -Mailbox $m.Identity
}
$devices | Export-Csv DeviceStats.csv
To use the above info, copy the code into a text file on one of your exchange servers and rename that file with the .ps1 extension. Next, open up the Exhcange Management Shell and use the ‘cd’ command to change directories until you are in the directory where the .ps1 file is located. Type ./Filename.ps1 and hit enter to run the script. The outputted CSV file will be located in the same directory that the file was run from.
