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
Hi,
I need to create a stats report that would tell me the number of replies in
specified queues. Not only the number of solved tickets, but literally the
number of replies - eg. if it takes 4 replies to close a ticket I need the
number 4 for that ticket, not count it as 1.
Is this possible?
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
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
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 all tickets that are closed ,
come only in closed state, and not in new state.
it is
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
Dear Michiel Beijen,
I just read the following mail what you sent with the solution.
I got an error message when I want to activate this option:
Framework - Frontend::Agent::Stats = Stats::UseAgentElementInStats = yes
Would you be so kind to help me about it?
I would be so happy if you can help
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
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 ticket owner? - Error message
** **
Dear Michiel Beijen,
I just read
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
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
Hi list,
We use OTRS 2.4.7
We want to generate an overview with the open tickets and see who handles that
ticket.
- Is it possible to create a report (with the Statistics module) and have the
ticketowner in the report?
I do not see the ticketowner field in the selction list when creating a
Hi all,
At the end of the day ... I'd like to know, what I've done. Is there
any way to print all changes for a specific day - created / changed
documents (notes, new tickets ...). It would be great to have some kind
of a preview, i.e showing header and 5 to 10 lines.
Thanks
mb
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Simone
Girlanda
Verzonden: donderdag 9 februari 2006 9:06
Aan: User questions and discussions about OTRS.org
Onderwerp: R: R: [otrs] OTRS statistics
Thank you Edgar,
SELECT COUNT(DISTINCT(ticket_id
);
$statement-execute();
-Messaggio originale-
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di
Edgar Meij
Inviato: mercoledì 8 febbraio 2006 22.00
A: 'User questions and discussions about OTRS.org'
Oggetto: RE: R: [otrs] OTRS statistics
Hi Simone,
See attached image
about OTRS.org
Oggetto: Re: R: [otrs] OTRS statistics
There is an earlier post from me, I've included it below. And there is
a readme file within the archive, have you tried those?
Regards,
Edgar
---
Dear all,
During the greater part of this year I've been developing a statistics
module
questions and discussions about OTRS.org
Oggetto: R: R: [otrs] OTRS statistics
I have some problems using it:
fonts are not present in my system, where may I get them ? or may I use
other ?
my $GraphFont = '/usr/share/fonts/truetype/DINLt.ttf';
my $BoldFont = '/usr/share/fonts/truetype
Simone
Girlanda
Verzonden: woensdag 8 februari 2006 15:45
Aan: User questions and discussions about OTRS.org
Onderwerp: R: R: [otrs] OTRS statistics
icon file:
icon_vraagtaken.gif
is missed
It's possible to have a copy of it, or what do you intend to show there ?
thank you again
may you give us more detailed installation instruction ?
thank you
-Messaggio originale-
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di
Edgar Meij
Inviato: martedì 7 febbraio 2006 18.16
A: [EMAIL PROTECTED]
Cc: 'User questions and discussions about OTRS.'
Oggetto: [otrs] OTRS
: martedì 7 febbraio 2006 18.16
A: [EMAIL PROTECTED]
Cc: 'User questions and discussions about OTRS.'
Oggetto: [otrs] OTRS statistics
Hi Rémi,
Sure, see the attached file. If you have any questions, drop me an e-mail.
Regards,
Edgar
-Oorspronkelijk bericht-
Van: [EMAIL
: 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
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
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
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
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
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
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
27 matches
Mail list logo
