Exchange: Groups (Built-in)

[Esben_D]

The report below gives back a list of Exchange groups.

The report will only list groups when the following criteria are met:

• You have Lansweeper 7.1 or higher.
  
• There is Exchange user data scanned.

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