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