[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


How to Get Statistics from Exchange 2007 Regarding Mobile Devices

Published on
10,620 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"

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Join & Write a Comment

There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Check How effective MS Exchange Expert thinks Exchange Mailbox Recovery by SysTools IS. Visit the Official site to get detailed information:- https://www.systoolsgroup.com/exchange-recovery.html (https://www.systoolsgroup.com/exchange-recovery.h…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month