→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Nick_VDB
Champion Sweeper III
Old name: License: License expiration < 90 days

The report below gives back a list of software license contracts expiring in less than 90 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 90 days

Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 90 And Case
When tblLicenses.LicenseContract = 1 Then 'True' Else 'False' End = 'True'
Order By License
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now