florian asked a question.
I already noticed this behavior sometimes in the past.
These days again and I want to know if someone else see a problem here.
The fact is that a license with expired maintenance and upgrade rights is upgraded to a newer version because of missing release dates.
My example is based on these data:
SELECT A.ApplicationID,A.Name, A.ReleaseDate
FROM [SnowLicenseManager].[dbo].[tblApplication] as A
inner join SnowLicenseManager.dbo.tblApplicationFamily as AF on AF.FamilyIndex=A.FamilyIndex
where AF.Name='Winzip' and EditionIndex='110' and VersionIndex >= '10210'
order by EditionIndex,VersionIndex
The ouput is:
ApplicationID Name ReleaseDate
987CC480-F710-41B1-9FEB-6E9AF0039FF0 WinZip 21.0 Pro 2016-10-25
F7EDC4A2-F9C9-4F51-8381-733ACC69E080 WinZip 22 Pro 2017-10-01
0DF03133-DFE2-4F2E-9F06-8C0FA05C651C WinZip 23 Pro 2018-10-01
522F22E3-04EA-43D5-AA1C-1F1C66A09500 WinZip 24 Pro 2019-09-01
8940243E-17E6-48A4-88C1-DDACEB391E71 WinZip 25 Pro 2020-09-01
AD5E1818-8AE0-4608-8E3A-E1EE335377F0 WinZip 26 Pro 2021-08-31
5CDFFFC9-AE9A-46B1-9D18-12071E6D506B WinZip 27 Pro 1980-01-01
This behavior can be reproduced easily:
Record a license of Winzip 22 Pro with maintenance from 2017-11-01 until 2018-11-01 and upgrade rights
and then calculate a compliance. SLM will show you that you have the right for version 27 instead of version 23.
If you edit WinZip 27 Pro and specify a release date for example 2022-01-01 and recalculate the compliance the result
will be correct and show you rights for version 23.
I see a big problem here because it is not possible the investigate if all the applications has an release date specified.
And with described behavior there is the possibility that a lot of compliance results are wrong.
I think the default release date used is 1980-01-01 because running SELECT Name, ReleaseDate FROM SnowLicenseManager.dbo.tblApplication WHERE ReleaseDate LIKE '%1980%' in my test environment returns 678,125 rows. I.e if a release date cannot be found, its set to the start of the unix timestamp + 10 years.
If you have any applications that you know have an incorrect release date, you can contact the SRS team and have it updated.