License key

License key



SELECT ( systeminfo.workstationname )  "Workstation", 
       ( net.ipaddress )               "IP Address", 
       ( softl.softwarename )          "Software Name", 
       ( softwarelicenses.licensekey ) "LicenseKey" FROM   softwareinfo 
       LEFT JOIN softwarelist softl 
              ON softwareinfo.softwareid = softl.softwareid 
       LEFT JOIN softwaretype 
              ON Softl.softwaretypeid = softwaretype.softwaretypeid 
       LEFT JOIN systeminfo 
              ON softwareinfo.workstationid = systeminfo.workstationid 
       LEFT JOIN resources resource 
              ON systeminfo.workstationid = resource.resourceid 
       LEFT JOIN networkinfo net 
              ON softwareinfo.workstationid = net.workstationid 
       LEFT JOIN resources ress 
              ON softwareinfo.licenseid = ress.resourceid 
       LEFT JOIN softwarelicenses 
              ON ress.resourceid = softwarelicenses.resourceid 
WHERE  softwarelicenses.licensekey IS NOT NULL 
ORDER  BY 1 


          • Related Articles

          • 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 ...
          • 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 ...
          • License agreement

            SELECT DISTINCT licenseagreement.agreementnumber             "Agreement Number",                  softwaremanufacturer.NAME                    "Manufacturer",                  Longtodate(licenseagreement.acquisitiondate) "Acquisition Date",  ...
          • 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: ...
          • SSL server authentication and SSL Handshake

            The Standard SSL Handshake The following is a standard SSL handshake when RSA key exchange algorithm is used: 1.  Client Hello Information that the server needs to communicate with the client using SSL. This includes the SSL version number, cipher ...