Automatic Generating & Emailing Stats

Moderator: crythias

Locked
kool_kid
Znuny newbie
Posts: 86
Joined: 13 Feb 2011, 13:51
Znuny Version: 3

Automatic Generating & Emailing Stats

Post by kool_kid »

Hi,

I would like to test whether a stat report can be automatically generated and email to particular user. I saw a post but it was for V2 of otrs and used a file mkstat.pl file to do this job. The same file is not available in v3.
OTRS 3.1.10
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Automatic Generating & Emailing Stats

Post by crythias »

try otrs/bin/otrs.GenerateStats.pl
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
kool_kid
Znuny newbie
Posts: 86
Joined: 13 Feb 2011, 13:51
Znuny Version: 3

Re: Automatic Generating & Emailing Stats

Post by kool_kid »

Below is the error message im receiving.

I checked the language folder and all mentioned files are present.

Pointers to resolve this issue are welcome

Code: Select all

otrs\bin>perl otrs.GenerateStats.pl -n 10001 -r mail
@domain.com -s mail@domain.com -m 'test' -f Print
Use of uninitialized value $PDF::API2::Version::VERSION in pattern match (m//) at /otrs/Kernel/System/PDF.pm line 95.
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: PDF support activated in SysConfig but PDF::API2 0.57 or newer is required!

 Traceback (3020):
 Module: Kernel::System::PDF::new (v1.44) Line: 103
 Module: otrs.GenerateStats.pl (v1.3) Line: 69

Unrecognized escape \i passed through in regex; marked by <-- HERE in m/^C:\i <-- HERE netpub\wwwroot\otrs/(.*)\.pm$/ at /otrs/Kernel/Language.pm line 154.
Unrecognized escape \o passed through in regex; marked by <-- HERE in m/^C:\inetpub\wwwroot\o <-- HERE trs/(.*)\.pm$/ at C:/Inetpub/wwwroot/otrs/Kernel/Language.pm line 154.
ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_CA.pm.pm not found!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 168
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_CA.pm!
 Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_CA.pm (perl -cw)!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 169
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_Custom.pm.pm not found!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 168
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_Custom
.pm! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_Custom.pm (perl -cw)!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 169
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_FAQ.pm.pm not found!


 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 168
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_FAQ.pm
! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_FAQ.pm (perl -cw)!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 169
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_GB.pm.pm not found!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 168
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_GB.pm!
 Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_GB.pm (perl -cw)!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 169
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_ITSMChangeManagement.pm.pm not found!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 168
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMChangeManagement.pm! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMChangeManagement.pm (perl -cw)!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 169
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Module C:\inetpub\wwwroot\otrs/Kernel/Language/en_ITSMConfigItem.pm.pm not found!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 168
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: Sorry, can't load C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMConfigItem.pm! Check the C:\inetpub\wwwroot\otrs::Kernel::Language::en_ITSMConfigItem.pm (perl -cw)!

 Traceback (3020):
 Module: Kernel::Language::new (v1.77) Line: 169
 Module: otrs.GenerateStats.pl (v1.3) Line: 120

ERROR: OTRS-otrs.GenerateStats.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Jun 29 09:01:50 2011

 Message: StatNumber invalid!

 Traceback (3020):
 Module: Kernel::System::Stats::StatNumber2StatID (v1.100) Line: 1907
 Module: otrs.GenerateStats.pl (v1.3) Line: 164

ERROR: No StatNumber: 10001
OTRS 3.1.10
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Automatic Generating & Emailing Stats

Post by crythias »

PDF::API2 needs to be installed.
That's not likely all of the issue, but it's part of it.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
kool_kid
Znuny newbie
Posts: 86
Joined: 13 Feb 2011, 13:51
Znuny Version: 3

Re: Automatic Generating & Emailing Stats

Post by kool_kid »

PDF::API2 is already installed version 2.0.19 something.
OTRS 3.1.10
SLESSARD
Znuny advanced
Posts: 119
Joined: 12 Jan 2011, 22:35
Znuny Version: 4.x.x.x.x
Company: Self-Employed

Re: Automatic Generating & Emailing Stats

Post by SLESSARD »

Does such Stats Generator exist for v2.4?

if not, any idea how I could run stats automatically (schedule) ?? emailing them would be nice too but main goal is to run report on scheduler
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
SLESSARD
Znuny advanced
Posts: 119
Joined: 12 Jan 2011, 22:35
Znuny Version: 4.x.x.x.x
Company: Self-Employed

Re: Automatic Generating & Emailing Stats

Post by SLESSARD »

mkstats.pl seems to be it for 2.4 ... not much information though. If anyone is using ti to generate report and email them I'd appreciate more information on how to go about doing so

thanks everyone
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Automatic Generating & Emailing Stats

Post by jojo »

you'll find some documentation running the script with --help (or look into the code)
"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
Locked