Old name: License: License expiration < 60 days
The report below gives back a list of software license contracts expiring in less than 60 days.
The report will only list licenses that meet all of the following criteria:
- There is software license contract data
- The contract date will expire within the next 60 days
Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 60 And Case
When tblLicenses.LicenseContract = 1 Then 'True' Else 'False' End = 'True'
Order By License
