→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now