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 ...Software deployment in UEM when Service Request is approved
Use case: To initiate the software request from Service Catalog, approve the request and initiate the software deployment using the EC agent. Prerequisites: 1. To include required packages within a specific template, follow these steps: Begin by ...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 ...