The following script can be used to determine all users with Active Sync devices. The data is then written to a CSV file.
#Ppath to the CSV file for export
$exportfile = „c:\export.csv“#Name einer Mailboxdatenbank oder „alle“ um alle Mailbox Datenbanken zu erfassen
$database = „alle“#—————————————————————
„Benutzer;Typ;Seriennummer;Status“ | set-content „$exportfile“
if ($database -eq „alle“)
{
$mailboxes = get-MailboxDatabase | get-mailbox -ResultSize Unlimited
}
else
{
$mailboxes = get-MailboxDatabase „$database“ | get-mailbox -ResultSize Unlimited
}foreach ($mailbox in $mailboxes)
{
$devices = Get-ActiveSyncDevice -Mailbox $mailbox
foreach ($device in $devices)
{
$user = $mailbox.Name
$deviceSerial = $device.DeviceId
$DeviceType = $device.DeviceType
$DeviceState = $device.DeviceAccessState
if ($DeviceType -ne $NULL)
{
write-host „$user;$DeviceType;$deviceSerial;$DeviceState“
„$user;$DeviceType;$deviceSerial;$DeviceState“ | add-content „$exportfile“
}
}
}# www.frankysweb.de