Exchange 2010 powershell command to list Active Sync users with last successful sync
We upgraded to 2010 and I used to have a short powershell command that would like all my active sync users with the devicename, username, and lastsuccessful sync! Since we upgraded that script no longer works and I can get it listed on a per user basis but I'm looking for the whole company list type deal..... Thanks
September 13th, 2011 5:32pm

This is close: Get-ActiveSyncDevice | Get-ActiveSyncDeviceStatistics | FL DeviceID,Identity,LastSuccessSync Getting the user's name by itself is hard because it's not one of the properties of Get-ActiveSyncDeviceStatistics. Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2011 7:13pm

Hi tzenk, You can know "Get-ActiveSyncDeviceStatistics" detail from this document: Get-ActiveSyncDeviceStatistics http://technet.microsoft.com/en-us/library/aa996908.aspx Thanks, Evan Liu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com
September 14th, 2011 2:59am

Ed, That is really close do I have a way to clean up that command on the formatting side to make it a clean results? Travis
Free Windows Admin Tool Kit Click here and download it now
September 14th, 2011 1:03pm

You can do below to get it in column view. [PS] C:\temp>Get-ActiveSyncDevice | Get-ActiveSyncDeviceStatistics | select-object DeviceID,Identity,LastSuccessSync or export to csv [PS] C:\temp>Get-ActiveSyncDevice | Get-ActiveSyncDeviceStatistics | select-object DeviceID,Identity,LastSuccessSync |export-csv c:\temp\report.csv James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
September 14th, 2011 1:09pm

Hi Travis, How about the issue, any updates? Do you follow James’s suggestion to have a try? When you use this command to export to csv, I think it is better to add parameter –NotypeInformation, or the csv file will contain “#TYPE” followed by the fully-qualified name of the object type. Get-ActiveSyncDevice | Get-ActiveSyncDeviceStatistics | select-object DeviceID,Identity,LastSuccessSync |export-csv c:\temp\report.csv –NoTypeInformation Thanks, Evan Liu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com
Free Windows Admin Tool Kit Click here and download it now
September 16th, 2011 6:56am

Evan, When I run that command and export it's what I'm looking for just would like to clean up the Identity to only show the "Name" or "username" right now it shows me OU path from AD at the moment but were on the right track just need to polish it up any ideas?
September 28th, 2011 4:36pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics