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 ...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 ...