[otrs] Auto send Statistics by mail weekly

[Marcel Sánchez Toledano]

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

[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

[Marcel Sánchez Toledano]

That looks cool!

Any tutorial, manual or examples anywhere to automate this task?

Thanks,

Marcel Sánchez Toledano

[Gerald Young]

use cron.

[Sander Goudswaard]

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 yo...@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

 

[Marcel Sánchez Toledano]

That's just what I was looking for. Thanks very much!

Marcel Sánchez Toledano