Auto send Statistics by mail weekly

Hi, I was wondering if in OTRS there is the possibility to send statistics (an export in .CSV format) automatically by mail once a week, for example. Right now, we make a manually extraction every week but we want to automate this process. Thanks! *Marcel Sánchez Toledano*

Hi, 03.10.2014 07:09 - Marcel Sánchez Toledano schrieb:
I was wondering if in OTRS there is the possibility to send statistics (an export in .CSV format) automatically by mail once a week, for example.
you can use otrs.GenerateStats.pl via cron. :-) -- Florian

That looks cool!
Any tutorial, manual or examples anywhere to automate this task?
Thanks,
*Marcel Sánchez Toledano*
2014-10-03 8:06 GMT+02:00 Florian Edlhuber
Hi,
03.10.2014 07:09 - Marcel Sánchez Toledano schrieb:
I was wondering if in OTRS there is the possibility to send statistics (an export in .CSV format) automatically by mail once a week, for example.
you can use otrs.GenerateStats.pl via cron. :-)
-- Florian --------------------------------------------------------------------- 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

use cron. On Fri, Oct 3, 2014 at 12:26 PM, Marcel Sánchez Toledano < marcelsanchezt@gmail.com> wrote:
That looks cool!
Any tutorial, manual or examples anywhere to automate this task?
Thanks,
*Marcel Sánchez Toledano*
2014-10-03 8:06 GMT+02:00 Florian Edlhuber
: Hi,
03.10.2014 07:09 - Marcel Sánchez Toledano schrieb:
I was wondering if in OTRS there is the possibility to send statistics (an export in .CSV format) automatically by mail once a week, for example.
you can use otrs.GenerateStats.pl via cron. :-)
-- Florian --------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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

Example: go to $OTRS_HOME/var/cron and add your own text file, e.g. marcel_stats Use these contents (e.g. for quarterly reports): 1 0 1 1,4,7,10 * /opt/otrs/bin/otrs.GenerateStats.pl -n 10101 -r your@email.adddressmailto:your@email.adddress -s otrs@from_address -m 'OTRS Quarterly Report' -f Print The –n number is the report ID which you can find through the interface. Sander

That's just what I was looking for. Thanks very much! *Marcel Sánchez Toledano* 2014-10-08 16:54 GMT+02:00 Sander Goudswaard < s.goudswaard@westerscheldetunnel.nl>:
Example: go to $OTRS_HOME/var/cron and add your own text file, e.g. marcel_stats
Use these contents (e.g. for quarterly reports):
1 0 1 1,4,7,10 * /opt/otrs/bin/otrs.GenerateStats.pl -n 10101 -r your@email.adddress -s otrs@from_address -m 'OTRS Quarterly Report'
-f Print
The –n number is the report ID which you can find through the interface.
Sander
--------------------------------------------------------------------- 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
participants (4)
-
Florian Edlhuber
-
Gerald Young
-
Marcel Sánchez Toledano
-
Sander Goudswaard