Skip to content
October 24, 2009 / dw

report on what users are using activesync in Exchange 2007

A recent customer was looking for a convenient way to get a report on what users are using activesync in Exchange 2007.

Home to atthedatacenter.com

Get-Mailbox -ResultSize:Unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | Select-Object identity,devicemodel,LastSuccessSync | export-csv -path C:ActiveSyncExportsGetMailbox.csv

Then look for the C:ActiveSyncExports GetMailbox.csv file.

If you would like other information written, change or add to “identity,devicemodel,LastSuccessSync”

Possibilities are

FirstSyncTime, LastPolicyUpdateTime, LastSyncAttemptTime, LastSuccessSync, DeviceType, DeviceID, DeviceUserAgent, DeviceWipeSentTime, DeviceWipeRequestTime, DeviceWipeAckTime, ,LastPingHeartbeat, RecoveryPassword, DeviceModel, DeviceIMEI, DeviceFriendlyName, DeviceOS, DeviceOSLanguage, DevicePhoneNumber, Identity.

Another way would be to:

Log on to the cas servers. (This is the problem if you have multiple CAS servers. You will need to run this for each CAS server)

Look in C:inetpublogsLogFilesW3SVC1 for the latest logs. Replace the log name in the following command line. (You also need to make the directory ActiveSyncExports.

Export-ActiveSyncLog -FileName: “C:inetpublogsLogFilesW3SVC1u_ex091022.log” -StartDate:”10/20/09” -EndDate:”10/30/09” -UseGMT:$true -OutputPath:”c:ActiveSyncExports”

Run the command from the Exchange shell

Open c:ActiveSyncExports. The reports for that day will be in there. I think the user.csv will give you what you want. Unfortunately you will have to do this for each day (logs are created once a day) but it will give the user names as they logged on.

                                                                                                                                       Home to atthedatacenter.com

Hope it helps.  

dw

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: