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