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   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


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.
Answered 04/07/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
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)
Answered 04/07/2010 by: dtuttle
Purple Belt

Please log in to comment
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...
Answered 04/07/2010 by: mlathrop
Fifth Degree Brown Belt

Please log in to comment
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

Answered 04/12/2010 by: afzal
Fourth Degree Green Belt

Please log in to comment