License agreement

License agreement




SELECT DISTINCT licenseagreement.agreementnumber             "Agreement Number", 
                softwaremanufacturer.NAME                    "Manufacturer", 
                Longtodate(licenseagreement.acquisitiondate) "Acquisition Date", 
                Longtodate(licenseagreement.expirydate)      "Expiry Date", 
                CASE 
                  WHEN licenseagreement.expirydate = 0 THEN NULL 
                  ELSE 
                ( ( licenseagreement.expirydate / 1000 ) - 
                  Datediff(s, '19700101', Getdate()) ) / 60 / 60 / 24 
                END                                          "ExpireIn", 
                licenseagreement.pocustomid                  "PO No:", 
                agreementstatus.statusname                   "Status" FROM   licenseagreement 
       LEFT JOIN agreementstatus 
              ON licenseagreement.statusid = agreementstatus.statusid 
       LEFT JOIN softwaremanufacturer 
              ON licenseagreement.swmanufacturerid = 
                 softwaremanufacturer.swmanufacturerid 


          • Related Articles

          • License is Expired / License is invalid

            The application will not start if the license is expired / Corrupted. If the error is, Registration period is expired Open the command prompt with Admin privileges (Run it as Administrator) and point to the bin directory of ManageEngine ServiceDesk ...
          • How to apply renewed license when the existing one expires

            The steps have to be carried out from ServiceDesk installed server, Go to Services.msc and stop the ManageEngine ServiceDesk Plus Service, after which open the command prompt with Admin privileges (Run it as Administrator) and point to the bin ...
          • Unable to edit the Notification Rule in a different portal when default helpdesk's License is expired

            Issue: A redundant code is throwing an exception at a particular case - when Default Portal is license expired and other Portal Admin is trying to edit one of the Notification Rule. Fix: Removed the Redundant code. Issue ID: SD-97253 Compatibility: ...
          • License key

            SELECT ( systeminfo.workstationname )  "Workstation",         ( net.ipaddress )               "IP Address",         ( softl.softwarename )          "Software Name",         ( softwarelicenses.licensekey ) "LicenseKey" FROM   softwareinfo  ...
          • Software Compliance Report

            Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...