Sadly it was a painful process I’m still working on. But basically I had to isolate the software purchases that were associated to upgrades. That was easy enough to do by a small edit on the report in 6.5 called ‘software upgrades’ there is a line at the bottom
‘if (cast('%_LicenseGuid%' as uniqueidentifier) <> 0x0)
select * from vCon_SoftwareLicenseUpgrades where _LicenseGuid = %_LicenseGuid%”
if you remove “_LicenseGuid = %_LicenseGuid%”, and run the report you will see all the software purchases that have license upgrades.
Then it gets more complicated depending on how much you want to track and where you want to track it. First you have to get your total purchased license counts for those licenses that are affected by the upgraded purchases. Then what I’m doing right, now because it’s a small number of only 227 software licenses, is in the new system. Disassociate those purchases with the new license, make a single new purchase, as add all the line items in the purchase but basically put your new number you got from the old system as the total license count. It’s not pretty but it’s getting the result I need.
If I had a much larger number to deal with I would export what I needed and build a spread sheet of all the purchases and the license they are associated with, and a second spread sheet with the license and the total purchases. Then I would simply do a connector solution import.
There is some advanced sql writing you could do to use the compliance report and then use a sub query of the upgraded software list that would isolate the licenses you needed but I’ve not tried that yet.
I hope this helped or if it has confused you more let me know what I can clarify for you. Good luck.