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 14th, 2011 12:22am

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 14th, 2011 2:03am

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 9:49am

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 7:58pm

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 8:04pm

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 1:51pm

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 27th, 2011 11:14pm

Tzenk I`m having the same problem... there is a way to show only te username???
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2012 9:50am

For a simple list of names: Get-CASMailbox -Filter {hasactivesyncdevicepartnership -eq $true -and -not displayname -like "CAS_{*"} | Get-Mailbox | FL Name or you might prefer Get-CASMailbox -Filter {hasactivesyncdevicepartnership -eq $true -and -not displayname -like "CAS_{*"} | Get-Mailbox | FL Alias
May 29th, 2012 5:57am

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

Other recent topics Other recent topics