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 =
swinstallationkeyinfo.softwareinfoid
LEFT JOIN componentdefinitionsoftware
ON softwarelist.softwareid =
componentdefinitionsoftware.softwareid
LEFT JOIN resources resource
ON componentdefinitionsoftware.componentid = Resource.componentid
LEFT JOIN softwarelicenses
ON Resource.resourceid = softwarelicenses.resourceid
GROUP BY resource.resourcename
ORDER BY 1
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 swm.name "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 ...