Old name: License: License expiration < 30 days
The report below gives back a list of software license contracts expiring in less than 30 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 30 days
Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 30 And Case
When tblLicenses.LicenseContract = 1 Then 'True' Else 'False' End = 'True'
Order By License
