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 has to be installed on the server in which MSP is installed. Here is the link for Installation Steps,
2. functions.py: This package consists of all the functions that are used to handle the standard requirements of the customer. Most repeated requirements are written as separate functions. Depending on our use case, we can include these functions in our script.
3. configuration.json: This file maintains the configuration details of the installed server.
Execution steps:
1. Execute the below query and save the report with a title.
SELECT resource.RESOURCENAME "licensename",MAX(SoftwareList.SOFTWARENAME) "software_name",MAX(resource.EXPIRYDATE) "expirydate" FROM SoftwareInfo
LEFT JOIN SoftwareList ON SoftwareInfo.SOFTWAREID=SoftwareList.SOFTWAREID
LEFT JOIN ComponentDefinitionSoftware ON SoftwareList.SOFTWAREID=ComponentDefinitionSoftware.SOFTWAREID
LEFT JOIN Resources resource ON ComponentDefinitionSoftware.COMPONENTID=Resource.COMPONENTID where resource.EXPIRYDATE != '0'
GROUP BY resource.RESOURCENAME
2. Extract the ZIP file under ..\ManageEngine\ServiceDeskPlus-MSP\integration\custom_scripts - folder.
3. Edit the configuration.json and update the values.
4. Modify the email id in the script. Refer to the attached screenshot.
5. Configure a custom schedule to execute every day and pass the report saved as a parameter.
6. Go to Admin > Custom Schedule > give a schedule name > execute script > py send_licensereminder.py
Here the script will send reminder notification before 90,60 and 30 days respectively. If you want you can customize the days in the send_licensereminder_mail file.
New to ADSelfService Plus?
Related Articles
License agreement
SELECT DISTINCT licenseagreement.agreementnumber "Agreement Number", softwaremanufacturer.NAME "Manufacturer", Longtodate(licenseagreement.acquisitiondate) "Acquisition Date", ...Script to send notification to users on upcoming contracts
Please follow the below link to setup python on the server https://pitstop.manageengine.com/portal/en/kb/articles/how-to-setup-python-on-the-server-11-11-2019 Steps to configure 1. Extract the attached zip file in <Home>/integration/custom_scripts ...Script to send reminder mail to the users who haven't logged into the application for the last X days.
Please follow the below steps to send mail to the users who haven't logged in for the last X days: Step 1: Navigate to Reports--->New Query Report--->Execute the given query--->Now the report will be generated. Step 2: Save the report with a name ...Script to send reminder emails to requester when there is no response from them for more than a specified time period
There are scenarios where if the end-user is not responding for a specified period of time they need to be reminded of the same. This can be achieved using a script. Use case: Reminder emails should be triggered to requester when the request is ...Script to send notifications when a unknown request is raised
Use case The script will send email notifications to the address configured inside the script whenever a request is created under unknown requests. This notification will be sent to Admin Email Pre-requisite - Python should be installed in the ...