License agreement
SELECT DISTINCT licenseagreement.agreementnumber "Agreement Number",
softwaremanufacturer.NAME "Manufacturer",
Longtodate(licenseagreement.acquisitiondate) "Acquisition Date",
Longtodate(licenseagreement.expirydate) "Expiry Date",
CASE
WHEN licenseagreement.expirydate = 0 THEN NULL
ELSE
( ( licenseagreement.expirydate / 1000 ) -
Datediff(s, '19700101', Getdate()) ) / 60 / 60 / 24
END "ExpireIn",
licenseagreement.pocustomid "PO No:",
agreementstatus.statusname "Status" FROM licenseagreement
LEFT JOIN agreementstatus
ON licenseagreement.statusid = agreementstatus.statusid
LEFT JOIN softwaremanufacturer
ON licenseagreement.swmanufacturerid =
softwaremanufacturer.swmanufacturerid
New to ADSelfService Plus?
Related Articles
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 ...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 ...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: ...License key
SELECT ( systeminfo.workstationname ) "Workstation", ( net.ipaddress ) "IP Address", ( softl.softwarename ) "Software Name", ( softwarelicenses.licensekey ) "LicenseKey" FROM softwareinfo ...Mail fetching failure when incoming mail contains delimiter of module other than Request & change and Unsupported Release module
When processing a incoming mail that contains a delimiter of module other than Request & change and the License applied in the environment that doesn't have access to Release module, then the following mail fetching failure issue will occur. ...