How to Get Statistics from Exchange 2007 Regarding Mobile Devices

Published on
10,805 Points
1 Endorsement
Last Modified:
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"
Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free