How to Get Statistics from Exchange 2007 Regarding Mobile Devices

Published:
Updated:
Ever curious about the number of mobile devices being used in the organization?  Exchange 2007 has the ability to spit those numbers out&.you just have to ask the correct questions&

Using the Get-ActiveSyncDeviceStatistics cmdlet I was able to compile a list of devices that have synced within the last 2 weeks.

Get-Mailbox -ResultSize:Unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | Where {$_.LastSuccessSync -gt '11/02/2008'}


Now, massage that command a bit so that it exports the results in a better way:

Get-Mailbox -ResultSize:Unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | Where {$_.LastSuccessSync -gt '11/02/2008'} | Sort-Object -Property DeviceType,Identity | Select-Object @{name="EmailAddress";expression={$_.Identity.ToString().Split("\")[]0]}},DeviceType | Export-Csv -Path:"C:\Statistics.csv"
1
7,290 Views

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
You Belong in the World's Smartest IT Community