→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sukaitsu
Champion Sweeper
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
Thank you, Jeffrey Smith Enterprise Applications Security (319) 499-6310 JefSmith@geico.com
0 REPLIES 0