Hello All,
I am trying to build a SQL Query that mirrors the License Consumption page. I have found majority of the columns, but I am having difficulty finding the Consumed column (I have found other consumed columns, but none that match this one). Does anyone know which table(s) contain this data?
Thanks!
Jun 28, 2019 01:42 PM
Try the CalculatedConsumption column of the dbo.SoftwareLicensePointsConsumed view. Is this the data element you are looking for?
Jun 30, 2019 10:30 PM
Thank you for the reply. I tried this column, and while its returning consumption, when I look at the individual devices, its not matching the Consumption that shows up in the Flexera web page. I can match the Processor total, and Cores total, but Consumption is still a mystery.
Jul 02, 2019 08:37 AM
In that case, try the LicensesConsumed column of the dbo.SoftwareLicensePointsConsumed view.
While in general the value shown in the grid in the UI may be calculated from different details (particularly for consumption on virtual machines), looking at the LicensesConsumed column may get close enough to what you are wanting for your purposes.
If you are keen to understand how the data shown in the grid is really calculated, take a look at the definition of the Grid_LicenseComputerConsumptionListModelByLicense stored procedure. (But be warned - it is long and hairy!)
Jul 03, 2019 12:46 AM
Jul 09, 2019 01:57 PM