Evening-summary about todays tickets per mail

Moderator: crythias

Locked
cyrilstoll
Znuny newbie
Posts: 14
Joined: 24 Sep 2014, 09:00
Znuny Version: 5.0.15
Real Name: Cyril Stoll
Company: wlan-partner.com AG
Location: Zurich
Contact:

Evening-summary about todays tickets per mail

Post by cyrilstoll »

Hi there

My boss would very much like to get an email each evening/night with all the tickets that have been created during the day. Would be nice if this summary mail could include the subject line of each ticket that has been created. If this can be sorted by queue that would be even better.
Is there a way to do this with the statistics function in OTRS or would that be some kind of generic agent? I toyed around with both but was not really successful and would appreciate some hints on how this could be solved. Unfortunately the only thing that I've got working was that OTRS sends an email after every single ticket it creates and that's a bit too much.

Thanks already in advance and have a nice day/night (wherever you are)
Cyril
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Evening-summary about todays tickets per mail

Post by jojo »

it would be a statistic (Ticketlist) and sending it via cron to the needed email addresses.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
cyrilstoll
Znuny newbie
Posts: 14
Joined: 24 Sep 2014, 09:00
Znuny Version: 5.0.15
Real Name: Cyril Stoll
Company: wlan-partner.com AG
Location: Zurich
Contact:

Re: Evening-summary about todays tickets per mail

Post by cyrilstoll »

Hi jojo and others who might be interested

Thank you very much for that fast reply. After some try and error I finally created a Ticketlist (thanks for the hint!) which shows me pretty much what I (respectively my boss) want(s). Just as a guideline to others my statistics has the number 10014 and I want it to be generated and sent by email at midnight so my cronjob looks like this:

0 0 * * * bin/otrs.Console.pl Maint::Stats::Generate --number 10014 --mail-recipient boss@companyname.tld --mail-body 'stats attached' --format Print

Best regards,
Cyril
OTRS 5.0.15 (tarball install)
Linux <hostname> 4.4.0-57-generic #78-Ubuntu SMP Fri Dec 9 23:50:32 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
Locked