October 21st, 2009 by Mitchell Lintzen

To gather a complete list of mobile devices that are connecting to your Exchange 2007 Client Access Servers we need to retrieve the full list of mailboxes and then pipe that to the Get-ActiveSyncDeviceStatistics commmand as such:

$mob_devices = get-mailbox -ResultSize unlimited |%{ Get-ActiveSyncDeviceStatistics -mailbox $_}

That command will take a long time depending on how large your organization is. Then we’ll need to iterate through each device and weed out those devices that are no longer attempting to sync with Exchange. I’ve found that looking back 14 days should be enough time to eliminate the stale partnerships.

foreach($device in $mob_devices){
if((get-date).adddays(-14) -le $device.lastsyncattempttime){
$smtp = $device.identity.smtpaddress
$name = (get-mailbox $smtp).name
$type = $device.devicetype
“$smtp    $name    $type” | out-file -append ./mob_devices.txt
}
}

The last line outputs the SMTP address, user name, and device type to a text file. Have fun!