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 <[EMAIL PROTECTED]>
To: [email protected]
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
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
