cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
Software license contracts expiring in less than 60 days


Meets all the following criteria:
- Software license contract
- Contract expiration date in 1-60 days

Sorted on:
- Software name


Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseContract = 1 And
DateDiff(day, GetDate(), tblLicenses.LicenseExpiration) <= 60
Order By License
0 REPLIES 0