Exchange: Licenses (Built-in)

[Esben_D]

The report below gives back a list of Exchange licenses.

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

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

Select Top 1000000 'license.png' As Icon,
  tblExchangeLicense.LicenseId,
  tblExchangeLicense.LicenseName As DisplayName,
  Case
    When users.cnt Is Null Then 0
    Else users.cnt
  End As Users,
  tblExchangeServer.AssetId As ServerAssetId,
  tblExchangeServer.Name As ExchangeServer
From tblExchangeLicense
  Inner Join tblExchangeServer On tblExchangeServer.ServerId =
    tblExchangeLicense.ServerId
  Left Outer Join (Select Count(tblExchangeUserLicense.UserId) As cnt,
        tblExchangeUserLicense.LicenseId
      From tblExchangeUserLicense
      Group By tblExchangeUserLicense.LicenseId) users On users.LicenseId =
    tblExchangeLicense.LicenseId
Where tblExchangeLicense.UnitLabel = 'CAL'
Order By DisplayName