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
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 ...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 ...License agreement
SELECT DISTINCT licenseagreement.agreementnumber "Agreement Number", softwaremanufacturer.NAME "Manufacturer", Longtodate(licenseagreement.acquisitiondate) "Acquisition Date", ...Creating Integration Key
For builds after 11300, Steps to create Integration Key: Goto Admin > Integrations > Integration Key > New Please use an integration key with admin privilege, as there wont be any role related permission issues. Click Generate link under the ...Unable to edit the Notification Rule in a different portal when default helpdesk's License is expired
Issue: A redundant code is throwing an exception at a particular case - when Default Portal is license expired and other Portal Admin is trying to edit one of the Notification Rule. Fix: Removed the Redundant code. Issue ID: SD-97253 Compatibility: ...