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?

Give the manager a log-in and let them run a report in the stats section? ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Bo Wells Sent: November 6, 2006 13:18 To: otrs@otrs.org 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? Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipients (otrs@otrs.org), are confidential, and may be privileged. If you are not the intended recipient, you are hereby notified that any review, retransmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender (Frank Wakelin) immediately by return e-mail, and delete this message and any attachments from your system. Thank you. Information Confidentielle: Le present message, ainsi que tout fichier qui y est joint, est envoye a l'intention exclusive de son ou de ses destinataires (otrs@otrs.org); il est de nature confidentielle et peut constituer une information privilegiee. Nous avertissons toute personne autre que le destinataire prevu que tout examen, reacheminement, impression, copie, distribution ou autre utilisation de ce message et de tout fichier qui y est joint est strictement interdit. Si vous n'etes pas le destinataire prevu, veuillez en aviser immediatement l'expediteur (Frank Wakelin) par retour de courriel et supprimer ce message et tout document joint de votre systeme. Merci

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

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
participants (4)
-
Alexander Scholler
-
Bo Wells
-
Calderwood Brigitte
-
Frank Wakelin