[Solved] Automatic Ticket Creation based on date.

[abarry]

Hello Everyone, I would appreciate some assistance on setting something up. The company I work for has many SSL Certs and we are currently using an excel document to keep track of them and we need to keep checking it to see when a renewal is coming up. What I would like to do is somehow use OTRS to automatically generate a ticket about 30 days in advance of the cert expiring. Is there a way to put this on the calendar in OTRS and then have the system generate a ticket so many days out?

Thanks for all your thoughts and assistance in advance.

[jojo]

http://blog.otrs.org/2012/10/03/easy-ti ... interface/
http://blog.otrs.org/2010/11/11/proof-o ... -for-task/

[crythias]

schedule an email in Outlook to send at a specific day to the ticketing system.

[abarry]

schedule an email in Outlook to send at a specific day to the ticketing system.

Thanks Crythias, if that is the only way to do it instead of something within OTRS, then we will create a perl script to generate and send an email to OTRS and it will create a ticket for that specific SSL Cert.

Thanks for your help.

[reneeb]

<ad>
If you use the OTRS CMDB and if you have config items for you certificates, you might be interested in my CINotifications addon. If you're interested, I can create a demo system for you...
</ad>

[seberget2]

I can see that this is 'solved' but I would like to offer an additional way to solve this:

Is there a way to put this on the calendar in OTRS and then have the system generate a ticket so many days out?

Why don't you create a ticket today with an pending reminder state with a date that is 30 days before the certificate expires? Then this ticket would be opened by OTRS in time for you to handle it...