======Microsoft - Exchange - PowerShell - Mobile devices======


=====Report of all mobile devices syncing with Exchange=====

// Tested with Exchange Server 2013 and higher, and Exchange Online. //

Simple overview:
<code powershell>
Get-MobileDevice -ResultSize Unlimited | `
Select-Object `
Identity,FriendlyName,DeviceOS, `
DeviceUserAgent,ClientVersion,ClientType `
| Format-Table -AutoSize
</code>

Larger report with last sync time:

<code powershell>
# First export mobile device entries of ClientType REST as
# Get-MobileDeviceStatistics doesn't work on them.
Get-MobileDevice -ResultSize Unlimited | `
Where-Object {$_.ClientType -eq "REST"} | `
Select-Object `
  Identity, `
  FriendlyName, `
  DeviceOS, `
  DeviceModel, `
  DeviceType, `
  DeviceUserAgent, `
  ClientVersion, `
  FirstSyncTime, `
  DeviceAccessControlRule, `
  DeviceAccessState, `
  DeviceAccessStateReason | `
Export-Csv `
-Path C:\Temp\ExchangeMobileDeviceStatistics_REST.csv `
-NoTypeInformation

# Now export the devices that are not of ClientType REST.
$objMobileDevices = Get-MobileDevice -ResultSize Unlimited | `
Where-Object {$_.ClientType -ne "REST"}
$objDevices = @()
foreach ($objMobileDevice in $objMobileDevices) {
  $objDevice = Get-MobileDeviceStatistics `
  $($objMobileDevice.Guid | Select-Object -expandProperty GUID) | `
  Select-Object `
  Identity, `
  DeviceFriendlyName, `
  DeviceOS, `
  DeviceModel, `
  DeviceType, `
  DeviceUserAgent, `
  Status, `
  ClientVersion, `
  ClientType, `
  IsRemoteWipeSupported, `
  DevicePolicyApplied, `
  DevicePolicyApplicationStatus, `
  FirstSyncTime, `
  LastPolicyUpdateTime, `
  LastSyncAttemptTime, `
  LastSuccessSync, `
  DeviceAccessControlRule, `
  DeviceAccessState, `
  DeviceAccessStateReason
  $objDevices += $objDevice
}
$objDevices | Export-Csv `
-Path C:\Temp\ExchangeMobileDeviceStatistics.csv `
-NoTypeInformation
</code>

Sources:
  * [[https://docs.microsoft.com/en-us/powershell/module/exchange/get-mobiledevice?view=exchange-ps|Microsoft Docs - Get-MobileDevice]]
  * [[https://docs.microsoft.com/en-us/powershell/module/exchange/get-mobiledevicestatistics?view=exchange-ps|Microsoft Docs - Get-MobileDeviceStatistics]]
  * [[https://www.reddit.com/r/PowerShell/comments/8bs5uq/getmobiledevicestatistics_error/|Reddit - Get-MobileDeviceStatistics Error]]