‎06-17-2020 07:30 AM
Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 30 And
tblLicenses.LicenseContract = 1
Order By License
‎06-22-2020 04:21 PM
‎06-22-2020 01:58 PM
‎06-22-2020 07:34 AM
‎06-19-2020 05:11 PM
Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
Case
When tblLicenses.LicenseExpiration < DateAdd(dd, 0, GetDate()) Then
'#ffcccc'
When tblLicenses.LicenseExpiration < DateAdd(mm, 1, GetDate()) Then
'#ffff00'
Else '#bced91'
End As backgroundcolor,
tblLicenses.LicenseExpiration,
Case
When tblLicenses.LicenseExpiration < DateAdd(dd, 0, GetDate()) Then
'License Expired'
When tblLicenses.LicenseExpiration < DateAdd(mm, 1, GetDate()) Then
'License Ending Soon'
Else 'OK'
End As Status
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 30 And
tblLicenses.LicenseContract = 1
Order By License
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now