License Compliance: license expired (Built-in)

[Daniel_B]

Old name: License: license expired

The report below gives back a list of expired software license contracts

The report will only list licenses that meet all of the following criteria:

• There is software license contract data
  
• The contract date has expired

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