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 


                  New to ADSelfService Plus?

                    • Related Articles

                    • Query to show list of softwares with last scanned date and license key (MSSQL & PGSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) select systeminfo.workstationname "Workstation Name", SoftwareList.SOFTWARENAME "Software Name", LONGTODATE(SoftwareInfo.filecreatedtime) "Software Installed Date", LONGTODATE(audithistory.audittime) ...
                    • Query to show software license details (MSSQL & PGSQL)

                      Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL & MSSQL: SELECT resources.resourcename "License Name", Max(softwarelist.softwarename) "Software_Name", LONGTODATE(Max(resources.acquisitiondate)) "Acquisition ...
                    • 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 ...
                    • SQL Master Key Password FAQs

                      How to create the master key password. The user with dbcreator permissions can follow these steps to create the master key password: Open MSSQL Server Management Studio, right-click the database and choose New Query In the workspace, run the ...
                    • Remote Asset explorer license Explained

                      With the behavior change in the ServiceDeskPlus-MSP as mentioned in this post. Hope, you are aware that the Remote Asset explorer needs to be installed in each site, from where the assets will be pushed to ServiceDeskPlus-MSP. Considering the above, ...