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 :
> Hi,
>
> I need to create a stats report that would tell me the number of replies
> in specified queues
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? I
500
> From: Gerald Young
> Subject: Re: [otrs] otrs
statistics about carried forward tickets for
> a day
> To: "User questions and
discussions about OTRS."
> Message-ID:
>
> Content-Type: text
> Message: 3
> Date: Thu, 6 Feb 2014 07:21:18 -0500
> From: Gerald Young
> Subject: Re: [otrs] otrs statistics about carried forward tickets for
> a day
> To: "User questions and discussions about OTRS."
> Message-ID:
>
> Content-Type: text/plain; char
Use ticket_history table for your query.
On Thu, Feb 6, 2014 at 6:29 AM, Darshak Modi wrote:
> 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 clos
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 difficult
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
>
> ** **
>
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
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 hel
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
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
OT
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 sta
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
--
nt this way.
-- Edgar
> -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
>
&g
ndle->prepare($sql);
$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 statistic
PROTECTED] [mailto:[EMAIL PROTECTED] Namens 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 mi
User 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/
conto di
Edgar Meij
Inviato: martedì 7 febbraio 2006 18.28
A: User questions and discussions 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
[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 statistics
>
>
> Hi Rémi,
>
> Sure, see the attached file. If you have any questio
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: [
ur help I can get OTRS 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
>
about 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 discussi
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 stati
-Original Message-
> From: 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:
>
>
>
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
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 total no of new tickets, but it
doesn't show queue wise ?
Ravi
Edgar Meij wrote:
Ravi,
Were there any tickets *created* in this queue, or moved there later?
If the
Ravi,
Were there any tickets *created* in this queue, or moved there later?
If the latter is the case they won't show up (see README). What's the
result when you select no queues?
regards,
Edgar
--
'An approximate answer to the right question is worth a great deal
more than a precise answer t
Hi Edgar,
It gives me following o/p:-
mysql> SELECT COUNT(DISTINCT(ticket_id)) FROM ticket_history WHERE
history_type_id=1 AND create_time BETWEEN '2005-07-01' AND '2005-07-31'
+ INTERVAL 1 DAY;
++
| COUNT(DISTINCT(ticket_id)) |
++
|
Hi Ravi,
Can you try running a MySQL query and post the results:
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 OTRS are you using btw? You can also try and select
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
30 matches
Mail list logo
