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
Script to send multiple license expiry notification in Software License/Agreement
We can set only 1 notification for the license expiry. Using custom schedule multiple expiry notifications like 90 days before, 60 days before and 30 days before can be achieved using script. Prerequisites: 1. Python is a third party software that ...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 ...Remote Asset explorer license Explained
With the behavior change in the ServiceDeskPlus-MSP as mentioned in this post. Hope, you are aware that the Remote Asset explorer needs to be installed in each site, from where the assets will be pushed to ServiceDeskPlus-MSP. Considering the above, ...Adding AMS License to SDP MSP application
This KB article guides you in applying the AMS License file to the SDP MSP application. Step 1: Login to the SDP MSP application as an administrator. Step 2: Click the Help (?) icon at the top right corner. Step 3: Once you click the Help icon, there ...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 ...