We recently saw the Over Spent amount on the dashboard balloon to a very large number. Wanted to see if anyone knows how this is calculated as the amount is 10-20 times more then the total amount of all the purchases we have loaded into the system currently.
‎Nov 09, 2022 09:19 AM
@goody612 - Look at the Override Unit Price field on the Purchases tab of your licenses. If this value is provided, it is used on the Overspend Dashboard rather than any pricing provided in the purchases linked to the licenses.
A quick way to verify this is to add the Override Unit Price as an optional column to the All Licenses view.
‎Nov 09, 2022 09:58 AM
None of our licenses are populated with a "Override unit price" value.
‎Nov 09, 2022 10:08 AM - edited ‎Nov 09, 2022 10:09 AM
Is it possible to see how this number is pulled from the DB?
‎Nov 14, 2022 10:23 AM
The pricing information might also come from a purchase record associated with a license that has an unexpectedly high unit price. For example, if somebody enteres the total purchase amount gets as the unit price then you might see this kind of output.
I'm not sure exactly where in the database this detail will be coming from, but you could try executing the following stored procedure to see if it reflects what you're seeing in the UI:
EXEC dbo.Gadget_GetLicenseOptimization @Threashold = 0
‎Nov 25, 2022 03:54 AM