Recently I needed to report on the ActiveSync devices that were attached to our Exchange 2010 organisation, and which users they were accessing, and then export them to a CSV file.
This is the script:
$ActiveSyncDevices = @()
ForEach ($Mailbox in Get-Mailbox –Server MBX01) {
Get-ActiveSyncDeviceStatistics -Mailbox $Mailbox.Identity –ErrorAction SilentlyContinue | Select DeviceFriendlyName, Devicetype, DeviceUserAgent | ForEach-Object { $_ | Add-Member –MemberType NoteProperty -Name "MailboxIdentity" -value $Mailbox
$ActiveSyncDevices += $_ }
}
$ActiveSyncDevices | Export-csv c:\Path\To\File.csv
Walking through the script it gets all the mailboxes from the server MBX01, gets an object containing the ActiveSync device name, type and user agent. It then adds a property to that object called “MailboxIdentity” and adds it to that object. That object is then added to an array of objects called ActiveSyncDevices, which is then exported to CSV.
Hi,
I really appreciate your work, is a fantastic report, I search and I try different ways to generate this report and not be able to do after I find you work.
Tks.
Best Regards,
Oscar Pedroza
Very Nice. Is there a way I cann add the reult unlimites size switch and multiple servers in thic script. Thanks You
I made a modification to include all the mailbox servers in our org, and also include the last sync time so we can clean-up old devices.
$ActiveSyncDevices = @()
$MbxServers = Get-MailboxServer
foreach ($server in $MbxServers)
{
ForEach ($Mailbox in Get-Mailbox –Server $server) {
Get-ActiveSyncDeviceStatistics -Mailbox $Mailbox.Identity –ErrorAction SilentlyContinue | Select DeviceFriendlyName, Devicetype, DeviceUserAgent, LastSyncAttemptTime | ForEach-Object { $_ | Add-Member –MemberType NoteProperty -Name “MailboxIdentity” -value $Mailbox
$ActiveSyncDevices += $_ }
}
}
$ActiveSyncDevices | Export-csv c:\temp\ActiveSyncDeviceReport.csv -NoTypeInformation