Send reports (stats) automatically

[bmichelot]

Hi all,
I just want to know if there is way of working for periodically generate stat report and send it to a specific email address.
It's like reporting to a manager who are not able to access to the OTRS interface.
I was thinking that generic agent could done the job, but it seems to work only with tickets... no stats.
Thanks in advance for your reply.
Regards

[reneeb]

Create a cronjob that calls

$HOME/bin/otrs.GenerateStats.pl -n 10020 -f CSV -r 123@domain.com -r 123@domain.com -m "Weekly Open Ticket Report" -F WeeklyOpen

(you have to change the values of course )

[bmichelot]

Thanks a lot for you help.
Regards,

[bmichelot]

Hi reneeb,
I tried the solution your propose without success.
SO, to resume and to be sure that I did not make a mistake.
I create a cron job using GenericAgent.
I used the "Ticket Commands" function and fulfilled the field CMD as follow :

Code: Select all

$HOME/bin/otrs.GenerateStats.pl -n 10020 -f CSV -r 123@domain.com -r 123@domain.com -m "Weekly Open Ticket Report" -F WeeklyOpen

-n : been replaced by the number 10014 which corresponds to my stats
-f : been kept as I want to choose the CSV output format (according to my stat options)
-r : been replaced by my personal email address
-m : no change, but should correspond to the "subject" of the email
-F : filename of the CSV file
Is this true?
Thanks in advance for the help provided.
Regards,

[bmichelot]

I was impatient a little... it works... more than expected.
I planed to be send the stats every hour (to test the code), and I received 45 emails for one execution...
I have to investigate a little bit, to tune it better !
Regards,

[bmichelot]

I understood that the action is done as many as the number of tickets affected by the cron job.
Is this true?
How can I tune the cron job to do one sending only?
Thanks in advance for the help provided.
Regards,

[reneeb]

Can you show us what you have added in the crontab?

[bmichelot]

It will be a little bit difficult to paste an image of the settings due to the length of the parameters page.
Ticket filter :

• Queue filed : 2 items selected which contains 23 tickets

Ticket Commands :

• Send agent/customer : No
• CMD : $HOME/bin/otrs.GenerateStats.pl -n 10014 -f CSV -r myemail@mydomain.com -m "Envoi automatique de la stat 10014" -F Stat_10014
• Delete tickets : No

With those parameters, I received 23 email which corresponds to the number of tickets...
If I do not specify the filtering parameters, I got an error as follow :

Code: Select all

Backend ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Mon Aug 26 16:17:50 2013 Message: Attention: Can't run GenericAgent Job 'Envoi Périodique Stats' because no search attributes are used!. RemoteAddress: 192.168.12.46 RequestURI: /otrs/index.pl?Action=AdminGenericAgent;Subaction=RunNow;Profile=Envoi%20P%C3%A9riodique%20Stats;ChallengeToken=1551925c7b6eaaa1be337ea4832f0c7a; Traceback (9681): Module: Kernel::System::GenericAgent::JobRun (v1.86) Line: 437 Module: Kernel::Modules::AdminGenericAgent::Run (v1.108) Line: 87 Module: Kernel::System::Web::InterfaceAgent::Run (v1.73) Line: 864 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 44 Module: (eval) (v1.94) Line: 204 Module: ModPerl::RegistryCooker::run (v1.94) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.94) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31

[jojo]

don't create GenericAgents! Create a new Cron job for this

[bmichelot]

I was thinking that cron jobs was similar to GenericAgent.
How can I do a cron job?
Is "cron job" a script located in the home directory of the 'otrs' user?

[jojo]

man cron

[jfberni]

Jojo : Can you give an example how to used Static stat with GenerateStat.pl ?

[kalyana1315]

please check this

viewtopic.php?f=61&t=20415&p=80795&hili ... ics#p80811

Scheduled Reports in windows

viewtopic.php?f=53&t=21266

[bmichelot]

Hi all,
As I am not able to access to OTRS repertories and I would like to keep to ability to manage easily the automatic sending of report, I use the genericAgent filtered on a "ghost" ticket, which allow me to send only one report.
So, like said previously, I do not have the access the OTRS repertories, and I am not able to get the GenerateStats.pl --help function.
Could you please paste the list of parameter which can be used to?
I have to parameter another scheduled report sending in a pdf output.
Waiting an answer from my IT department will take a long time.
Regards,

[reneeb]

https://github.com/OTRS/otrs/blob/rel-3 ... teStats.pl

[tdtmusic]

Hello. Sorry to revive an old thread but I recently tried to set up automatic report sending in OTRS and I followed the instructions on this page. It worked fine, but I do have some questions, maybe some of you can help me. So:
- is it possible to set up the email message (the one after -m parameter) with line breaks somehow? Having only one continuous line is kind of ugly
- is it possible to have some sort of signature to the email? Like an image or logo;
- I've noticed that the sender of the email is the otrs default email account, but if I use the -s parameter I can use another address, right? If so, how is the authentication being done? I tried to use another address from the same domain but I got an auth error.

That's all, thank you!