Re: [otrs] Send a daily email of open tickets to admin?

Hi, Calderwood Brigitte schrieb:

We also run a monthly stats report on the overview of tickets. I then combine open/new, closed/resolved and import into excel as a cvs file from otrs. If you find out how to have otrs generate a daily email of open tickets...please let me know. Brigitte Calderwood ----- Original Message ----- From: Bo Wells To: otrs@otrs.org Sent: Monday, November 6, 2006 2:18:00 PM GMT-0700 Subject: [otrs] Send a daily email of open tickets to admin?

Our manager wants a daily email of all open tickets. I'm not sure this is possible, but does anyone know of a way to get the OTRS server to send a daily email of non-closed tickets?

I think the mailing of a search-result (searching for all open tickets) would be a solution for this request. Without having implemented, try this: * make a search for open-tickets with output-type csv or print * make this search via command-prompt, e.g. with wget * pipe the output into a mail * run all this as cronjob Another "quick&dirty solution" would be: * make a DB-direct query and pipe the result to mail Bye, Alex