KACE Product Support

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

 

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?

You will have to manually edit the SQL with the MySQL functions date functions to get this to work correctly:


http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html


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:

CURDATE(), DATE_ADD(), and DATE_SUB()

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

DATE_SUB(CURDATE(), INTERVAL 14 DAY)