Re: [otrs] OTRS Statistics

2014-10-27 Thread Lars Jørgensen
I don't think it's possible from within OTRS. But you can always access the database (use a read-only connection) and pull the relevant data yourself. 2014-10-22 16:04 GMT+02:00 Michal Vavak mva...@gmail.com: Hi, I need to create a stats report that would tell me the number of replies in

Re: [otrs] otrs statistics about carried forward tickets for a day

2014-02-07 Thread Mike Morris
2014 07:21:18 -0500 From: Gerald Young cryth...@gmail.com Subject: Re: [otrs] otrs statistics about carried forward tickets for a day To: User questions and discussions about OTRS. otrs@otrs.org Message-ID: cakk-oujfdwfbfyh--xd1bkrdqjdffzergpjdk2bgt3kyxmg...@mail.gmail.com Content-Type

Re: [otrs] otrs statistics about carried forward tickets for a day

2014-02-07 Thread Darshak Modi
cryth...@gmail.com Subject: Re: [otrs] otrs statistics about carried forward tickets for a day To: "User questions and discussions about OTRS." otrs@otrs.org Message-ID: cakk-oujfdwfbfyh--xd1bkrdqjdffzergpjdk2bgt3kyx

Re: [otrs] otrs statistics about carried forward tickets for a day

2014-02-06 Thread Gerald Young
Use ticket_history table for your query. On Thu, Feb 6, 2014 at 6:29 AM, Darshak Modi darshak.m...@elitecore.comwrote: hi, we want find how many tickets created in a day [ new ], how many are worked upon [ closed ] and if any tickets remain opened. I am generating using report tool. But

Re: [otrs] OTRS statistics with ticket owner? - Error message

2013-03-11 Thread Gadow, Shawn
That is a permissions issue. You need to have the correct file permissions set to allow OTRS to change the config From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Zsolt Hajduk Sent: Monday, March 11, 2013 9:01 AM To: otrs@otrs.org Subject: [otrs] OTRS statistics with

Re: [otrs] OTRS statistics with ticket owner? - Error message

2013-03-11 Thread Zsolt Hajduk
Dear Shawn, Thank you very much the information. Would you help me to specify the file name and the correct permissions settings? Best regards, Zsolt 2013/3/11 Gadow, Shawn sga...@ocusd.net That is a permissions issue. You need to have the correct file permissions set to allow OTRS to

Re: [otrs] OTRS statistics with ticket owner?

2013-01-21 Thread Jurjen Verhoeff
and discussions about OTRS. Subject: Re: [otrs] OTRS statistics with ticket owner? Hi Jurjen, You'll have to activate it in SysConfig: Framework - Frontend::Agent::Stats = Stats::UseAgentElementInStats = yes This is because OTRS is by origin German, and in Germany it can be forbidden to track performance

Re: [otrs] OTRS statistics with ticket owner?

2013-01-17 Thread Michiel Beijen
Hi Jurjen, You'll have to activate it in SysConfig: Framework - Frontend::Agent::Stats = Stats::UseAgentElementInStats = yes This is because OTRS is by origin German, and in Germany it can be forbidden to track performance of your individual employees Michiel Beijen Senior Consultant

RE: [otrs] OTRS statistics

2006-01-27 Thread Danie Theron
: Edgar Meij [mailto:[EMAIL PROTECTED] Sent: 09 August 2005 04:49 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] OTRS statistics Hi Ravi, Can you try running a MySQL query and post the results: connect to mysql, e.g. mysql -u [user] -h [host] -p USE otrs

RE: [otrs] OTRS statistics

2006-01-27 Thread BALAN, Daniel
I am interested in this too. Daniel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Danie Theron Sent: Friday, January 27, 2006 10:09 AM To: User questions and discussions about OTRS.org Subject: RE: [otrs] OTRS statistics Hi Edgar , I

RE: [otrs] OTRS statistics

2006-01-27 Thread David Hathiramani
OTRS.org' Subject: RE: [otrs] OTRS statistics I am interested in this too. Daniel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Danie Theron Sent: Friday, January 27, 2006 10:09 AM To: User questions and discussions about OTRS.org Subject: RE

RE: [otrs] OTRS statistics

2006-01-27 Thread Danie Theron
to replace RT :P -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Hathiramani Sent: 27 January 2006 03:33 PM To: User questions and discussions about OTRS.org Subject: RE: [otrs] OTRS statistics As far as I am aware, the module that you

Re: [otrs] OTRS statistics

2005-08-10 Thread Edgar Meij
Then u should select table as export with no queues selected and find out in which queues tickets get created... Edgar On 8/10/05, Ravi AHUJA [EMAIL PROTECTED] wrote: Hi, Not for all the tickest, but few tickets were moved from one queue to another. When i select no queues, it do show me

Re: [otrs] OTRS statistics

2005-08-09 Thread Ravi AHUJA
Hi, I have tried it , but for all my queues it gives, this standard message:- Error, No tickets created in Queues: STORAGE/Backup/Restore/Archive/Quota, between 01-07-2005 and 31-07-2005 Any help. Thanks Ravi Ahuja Edgar Meij - Hostnet Helpdesk wrote: Dear all, During the greater part

Re: [otrs] OTRS statistics

2005-08-09 Thread Edgar Meij
Hi Ravi, Can you try running a MySQL query and post the results: connect to mysql, e.g. mysql -u [user] -h [host] -p USE otrs SELECT COUNT(DISTINCT(ticket_id)) FROM ticket_history WHERE history_type_id=1 AND create_time BETWEEN '2004-07-01' AND '2004-07-31' + INTERVAL 1 DAY; Which version of