• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1028
  • Last Modified:

Exchange 2010 Activesync - Mobile Phone Report

With Exchange 2003 I had an batch and SQL script that would pull all the Activesync Users (from the logs) and generate a csv that showed me who and what phones were connecting to my server (and how many times). How do I accomplish this with Exchange 2010?
0
Sedryn
Asked:
Sedryn
  • 2
1 Solution
 
digerati1Commented:
You will need to do that through the exchange shell.  It will most likely require a script to be written but would check the forum or google to see if anyone has one already written.
0
 
Kamalasekar ParthasarathyMessaging SupportCommented:

You can try this command to view the device information

Get-ActiveSyncdevice | FL UserDisplayName, DeviceType, DeviceModel > c:\test.csv

0
 
SedrynAuthor Commented:
Sekar,

This worked, Get-ActiveSyncdevice | FL UserDisplayName, DeviceType, DeviceModel > c:\test.csv
However, the UserDisplayName is including the OU path which is long and ends up truncating after 85 characters which does not make it to the users ID. Any ideas?
0
 
SedrynAuthor Commented:
Got it.  I will just extract it from the DistinguishedName.
Get-ActiveSyncdevice | FL DistinguishedName, DeviceType, DeviceModel > c:\test.csv

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now