‎03-05-2019 01:00 PM
Select Top 1000000 'arrow_refresh.png' As Icon,
Case
When tblIntuneDevice.ManagedDeviceName Is Null Then
tblExchangeActiveSyncDevice.DeviceFriendlyName
Else tblIntuneDevice.ManagedDeviceName
End As DeviceAssetName,
tblIntuneDevice.AssetId As DeviceAssetId,
tblExchangeActiveSyncDevice.DeviceModel,
tblExchangeActiveSyncDevice.DeviceOs,
tblExchangeActiveSyncDevice.ClientType,
tblExchangeActiveSyncDevice.DeviceAccessState As AccessState,
tblExchangeActiveSyncDevice.FirstSyncTime,
tblExchangeActiveSyncDevice.LastSuccessSync,
tblExchangeActiveSyncDevice.Mailbox,
tblExchangeServer.AssetId As ServerAssetId,
tblExchangeServer.Name As ExchangeServer
From tblExchangeActiveSyncDevice
Inner Join tblExchangeServer On tblExchangeServer.ServerId =
tblExchangeActiveSyncDevice.ServerId
Left Outer Join tblIntuneDevice On tblIntuneDevice.Imei =
tblExchangeActiveSyncDevice.DeviceImei
Order By tblExchangeActiveSyncDevice.DeviceFriendlyName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now