How do I Configure an Alert on license expiration in x amount of days

One of our objectives is to be able to report on when our licenses/warranties are nearing expiration. How do you configure the filters/alerts to trigger when a license is nearing it's end date in the asset management module? I see options for > & <, and this will work for an individual report where you specify the date, but in order to configure an alert,the system needs to take a difference between today's date and the expiration date.

0 Comments   [ + ] Show comments

Answers (4)

Posted by: itsuman 8 years ago
White Belt

I had done this by the follwing  way.


1. Click Reporting 

2.Select Classic report

3. Create new report 

In the reports craetion wizard you can set the rules accoding your condition.

please find the attached image


Posted by: itsuman 8 years ago
White Belt

Posted by: Thaiguy78 13 years ago
Senior Yellow Belt
So, it looks like I should be able to use a system variable, like $DATE. This shows up properly in the filter, but if I try to put something like $DATE + 60 or $DATE -d "60 days" the filter ignores the modification of the variable. What is the syntax to allow for variable modification in the filter dialogs?
Posted by: Thomas.Babcock 13 years ago
Blue Belt
You will have to manually edit the SQL with the MySQL functions date functions to get this to work correctly:


What I do is setup the filter using the normal drop-downs first to get everything working correctly expect the date and then modify the SQL under the Reports tab.

The main ones to use are:


Here is an example to limit the filter to only items that are older than 2 weeks old:

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ