Office 365 Mobil Cihaz Raporu Powershell

Merhabalar,

Sistem yöneticileri olarak, mail sistemine hangi kullanıcının hangi cihaz veya cihazlar ile bağlandığını listelemek bizler için çok önemli. Office 365 kullanan firmalar için mobil cihaz raporunu aşağıdaki powershell scripti kullanarak csv formatında alabiliriz.

Script içerisinde değiştirmeniz gereken tek değişken “$Path” değişkeni. Raporun istediğiniz bir dizine çıkarılması için buraya dizine ait yolu yazmanız yeterli olacaktır.

$Path = "C:\MobileDevice.csv"
$mailboxes = Get-Mailbox -ResultSize unlimited
foreach ($mailbox in $mailboxes) {
$devices = Get-ActiveSyncDeviceStatistics -Mailbox $mailbox.samaccountname
#If the current mailbox has an ActiveSync device associated, loop through each device
if ($devices) {
foreach ($device in $devices){
#Create a new object and add custom note properties for each device. Comment out the ones you don't need
$deviceobj = New-Object -TypeName psobject
$deviceobj | Add-Member -Name DisplayName -Value $mailbox.DisplayName -MemberType NoteProperty
$deviceobj | Add-Member -Name UPN -Value $mailbox.UserPrincipalName -MemberType NoteProperty
$deviceobj | Add-Member -Name Status -Value $device.Status -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceID -Value $device.DeviceID -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceEnableOutboundSMS -Value $device.DeviceEnableOutboundSMS -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceMobileOperator -Value $device.DeviceMobileOperator -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceAccessState -Value $device.DeviceAccessState -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceAccessStateReason -Value $device.DeviceAccessStateReason -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceAccessControlRule -Value $device.DeviceAccessControlRule -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceType -Value $device.DeviceType -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceUserAgent -Value $device.DeviceUserAgent -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceModel -Value $device.DeviceModel -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceFriendlyName -Value $device.DeviceFriendlyName -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceOS -Value $device.DeviceOS -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceOSLanguage -Value $device.DeviceOSLanguage -MemberType NoteProperty
$deviceobj | Add-Member -Name IsRemoteWipeSupported -Value $device.IsRemoteWipeSupported -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceWipeSentTime -Value $device.DeviceWipeSentTime -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceWipeRequestTime -Value $device.DeviceWipeRequestTime -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceWipeAckTime -Value $device.DeviceWipeAckTime -MemberType NoteProperty
$deviceobj | Add-Member -Name LastDeviceWipeRequestor -Value $device.LastDeviceWipeRequestor -MemberType NoteProperty
$deviceobj | Add-Member -Name DevicePolicyApplied -Value $device.DevicePolicyApplied -MemberType NoteProperty
$deviceobj | Add-Member -Name DevicePolicyApplicationStatus -Value $device.DevicePolicyApplicationStatus -MemberType NoteProperty
$deviceobj | Add-Member -Name DeviceActiveSyncVersion -Value $device.DeviceActiveSyncVersion -MemberType NoteProperty
$deviceobj | Add-Member -Name FirstSyncTime -Value ($device.FirstSyncTime).ToString("yyyy-MM-dd HH:mm:ss") -MemberType NoteProperty
$deviceobj | Add-Member -Name LastPolicyUpdateTime -Value ($device.LastPolicyUpdateTime).ToString("yyyy-MM-dd HH:mm:ss") -MemberType NoteProperty
$deviceobj | Add-Member -Name LastSyncAttemptTime -Value ($device.LastSyncAttemptTime).ToString("yyyy-MM-dd HH:mm:ss") -MemberType NoteProperty
$deviceobj | Add-Member -Name LastSuccessSync -Value ($device.LastSuccessSync).ToString("yyyy-MM-dd HH:mm:ss") -MemberType NoteProperty
$deviceobj | Add-Member -Name NumberOfFoldersSynced -Value $device.NumberOfFoldersSynced -MemberType NoteProperty
Write-Output -InputObject $deviceobj
Export-Csv -Path $Path -InputObject $deviceobj -NoTypeInformation -Encoding UTF8 -Delimiter ";" -Append
}
}
}

Umarım faydalı bir makale olmuştur. Bir sonraki makalemizde görüşmek üzere.