/build/static/layout/Breadcrumb_cap_w.png

Get alerted before the Maintenance/ Warranty Expiry of any Computer using Kbox

1. Create Maintenance Expiry Date field under Asset Tab

2. Create Email Notification using Maintenance Expiry Date field

3. Select "Maintenance Expiry < DATE_ADD(CURDATE(), INTERVAL 30 DAY)" for notification of maintenance expiry in 30 days

On clicking "Create Notification",  Reporting Email Alerts page will be displayed

Select the email alerts and select the run frequency, hourly, daily, weekly or monthly.

You will notice that apostrophe has been added in the front and back of the string of characters you supplied earlier, "DATE_ADD(CURDATE(), INTERVAL 30 DAY)",  Remove the 2 apostrophes as they turn the date into a character string that invalidates arithmetical comparison


Comments

This post is locked
 
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