License asset expiration date notification

Is the expiration date in the license asset field supposed to trigger a notification? If not, has anyone created this. I would like to generate a notification of impending license expiration...not sure how...

0 Comments   [ + ] Show comments

Answers (4)

Posted by: airwolf 12 years ago
Red Belt
No assets trigger any type of notifications by default. Take a look at the thread about email notification on help desk tickets - http://itninja.com/question/faulttree-109953. You need to use the same principles to create a rule to notify you when the expiration date is less than 30 days from the current time. I'd write the rule for you, but your asset tables and field numbers are probably not the same as mine.
Posted by: dtuttle 12 years ago
Purple Belt
Like Andy said, it depends on your table setup. First find out what table the information is stored in, then your can probably just use a simple select statement, something between now() and date_add(now(), INTERVAL 90 days)
Posted by: mlathrop 12 years ago
Fifth Degree Brown Belt
Thanks guys, but I am not familar with the underlying DB structure and only slightly more familar with SQL query...I make do with Report Wizard or stealing existing code...
Posted by: afzal 12 years ago
Fourth Degree Green Belt
Please view my Articl on Appdeploy, Get alerted before the Maintenance/ Warranty Expiry of any Computer using Kbox, i hope you will get the idea from this, let me know if further help is required

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