Scheduled Reports

[fritzfreund]

I'm trying to schedule reports to be emailed to a manager. I have created the reports in Statistics, however I can't figure out how to schedule the job. I assume it will simply be a CRON job and I've found threads that tell people how to do it. However they are wanting to call mkStats.pl however I don't have one. I am assuming that they are running 2.x? What would be the script to do this on 3.1.11?

Thank you in advance for the help.

[jojo]

bin/otrs.GenerateStats.pl

[fritzfreund]

LOL....

wow I must just be blind...

[fritzfreund]

So, in case anyone else is looking for details on doing this. here is what I did.

log into your system as root (or use sudo)
crontab -u <otrsuser> -e
I added the following line to run a weekly report:
0 7 * * 1 $HOME/bin/otrs.GenerateStats.pl -n 10020 -f CSV -r tom@domain.com -r fred@domain.com -r tony@domain.com -m "Weekly Open Ticket Report" -F WeeklyOpen

The Report runs every Monday at 7:00AM (0 7 * * 1) (Minute Hour DayOfMonth Month DayOfWeek)
The report number is 10020. (-n 10020)
It's sending as a CSV file. (see below for what I had to tweak) (-f CSV)
It's sending to 3 poeple. (-r tom@domain.com -r fred@.....)
The message is Weekly Open Ticket Report. (-m "Weekly Open Ticket Report")
And the file name is WeeklyOpen.csv. (-F WeeklyOpen)

CSV fix
So, to get CSV working correctly, I actually had to edit otrs.GenerateStats.pl to use a comma(,) instead of a semi-colon(;).
change the following on line 148 to a comma.
my $Separator = $Opts{S} || ',';

[jojo]

did you try -S <seperator> ?

[fritzfreund]

I didn't.

Do you by any chance have a site that has all the switches spelled out for the scripts?

[crythias]

try otrs.RandomScript.pl --help