Software Licenses

Software Licenses

SELECT resource.resourcename                 "License Name", 
       Max(softwarelist.softwarename)        "Software_Name", 
       Max(resource.acquisitiondate)         "Acquisition Date", 
       Max(resource.expirydate)              "Expiry Date", 
       Max(swinstallationkeyinfo.productid)  "Software_ID", 
       Max(swinstallationkeyinfo.productkey) "Software_Key" FROM   softwareinfo 
       LEFT JOIN softwarelist 
              ON softwareinfo.softwareid = softwarelist.softwareid 
       LEFT JOIN swinstallationkeyinfo 
              ON softwareinfo.softwareinfoid = 
       LEFT JOIN componentdefinitionsoftware 
              ON softwarelist.softwareid = 
       LEFT JOIN resources resource 
              ON componentdefinitionsoftware.componentid = Resource.componentid 
       LEFT JOIN softwarelicenses 
              ON Resource.resourceid = softwarelicenses.resourceid 
GROUP  BY resource.resourcename 

                    New to ADSelfService Plus?

                      • Related Articles

                      • Software details

                        SELECT systeminfo.workstationname             "Workstation",         Max(aaauser.first_name)                "User",         ( softwarelist.softwarename )          "Software_Name",         Max(softwaretype.softwaretype)         "Software_Type",  ...
                      • Specific Software

                        SELECT ( softl.softwarename )           "Software Name",         Max(workstation.workstationname) "Workstation",         Max(workstation.model)           "Model",         Max(aaauser.first_name)          "User",  ...
                      • How to export software data in CSV format?

                        Steps to export Software data in CSV format 1. Login to ServiceDesk Plus/AssetExplorer. 2. Click on the Reports tab and then click on New Query Report button. 3. Copy and paste the following query and click Run Report. select "Scanned ...
                      • Query to extract the “Software-License Additional Fields” along with the existing additional fields (PGSQL)

                        (Applicable for builds 14300 & above) Below query has been modified to add a LEFT JOIN between the additional fields table and the table from which you extracted the softwares: QUERY: SELECT SUM(scd.ALLOCATED) AS "Allocated", ...
                      • 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 ...