License: Software licensekey usage ()

[sukaitsu]

The following report will only be useful if you have already configured licenses under Edit purchased licenses in Lansweeper. Unlike the built in reports that group license usage by Software Titles, this report will list each License Key as a separate line item. If you have multiple license keys for a software title and want to know which keys are in use and how many seats are left.. now you can!

Select Top 1000000 tblLicenses.softwareName,
  tblSublicensesOrders.Ordernumber,
  Count(tblSerialnumber.ProductKey) As [In Use],
  tblSublicensesOrders.Nrlicenses Purchased,
  Cast(tblSublicensesOrders.Licensekey As nvarchar(max)) As [License Key]
From tblLicenses
  Inner Join tblSublicensesOrders On tblLicenses.LicenseidID =
    tblSublicensesOrders.LicenseidID
  Inner Join tblSerialnumber On tblSerialnumber.ProductKey =
    Cast(tblSublicensesOrders.Licensekey As nvarchar(max))
Group By tblLicenses.softwareName,
  tblSublicensesOrders.Ordernumber,
  tblSublicensesOrders.Nrlicenses,
  Cast(tblSublicensesOrders.Licensekey As nvarchar(max))

Thank you,

Jeffrey