Re: [otrs] Stats about escalations

On 2011-10-06 12:41, Michiel Beijen wrote: Hi Ugo, the timeout field is used for auto unlocking of tickets. The until_time field is used for storing the pending date. Unfortunately the escalation times are not stored at the ticket level, you would need to parse the ticket history to extract the

Re: [otrs] Stats about escalations

Hi Ugo, the timeout field is used for auto unlocking of tickets. The until_time field is used for storing the pending date. Unfortunately the escalation times are not stored at the ticket level, you would need to parse the ticket history to extract the data. -- Mike. On Sep 29, 2011 7:10 PM, "Ug

[otrs] Stats about escalations

Hi, I'm trying to find out a way to generate a report of the escalation that have occured in the last month. I've managed to get different information on tickets from the tickets table, but I don't see any fields that would let me know if the ticket has been escalated. There are a few fields

Re: [otrs] Stats to report ticket-id and its description

s? > > > De: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] En nombre de Marco Vannini > Enviado el: viernes, 06 de mayo de 2011 09:46 a.m. > Para: User questions and discussions about OTRS. > Asunto: Re: [otrs] Stats to report ticket-id and its description > > did you toug

Re: [otrs] Stats to report ticket-id and its description

. Para: User questions and discussions about OTRS. Asunto: Re: [otrs] Stats to report ticket-id and its description did you tought to make a search with the criteria you need from the console and then export the results in csv to process data in other tools (ie excel) ? MV On Fri, May 6, 2011 at 3

Re: [otrs] Stats to report ticket-id and its description

did you tought to make a search with the criteria you need from the console and then export the results in csv to process data in other tools (ie excel) ? MV On Fri, May 6, 2011 at 3:37 PM, Augusto Garcia | CGTEC S.A. < soport...@cgtec.com.py> wrote: > Hi > > > > I saw the same question in an ar

[otrs] Stats to report ticket-id and its description

Hi I saw the same question in an archive of the list but couldn't find an answer, does anyone know how to get a list of tickets with id and a description of each ticket? What I can get by now is the amount of tickets open and closed but no ticket information is shown. Hope you can help me! Bes

Re: [otrs] Stats

Dear Claude, Statistics are stored mainly in the table xml_storage. Cheers, Nils On 23.02.2011, at 12:33, claude wrote: > I don't find where stat request are stored in database. — Nils Leideck Senior Consultant http://webint.cryptonode.de / a Fractal project

[otrs] Stats

Hi, I don't find where stat request are stored in database. Can anyone help me ? Thanks and regards Claude - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: ht

[otrs] stats accesible from customer.pl

helow using otrs 2.7.x, is there an easy way to let custoems from customer.pl frontend to acess to stats? LD - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: htt

Re: [otrs] Stats question

Dear Jason, this option needs to be enabled in the SysConfig first. SysConfig -> Framework -> Frontend::Agent::Stats -> Stats::UseAgentElementInStats It is disabled by default because of some laws disallowing to measure performance per individual agent ;-) Cheers, Nils — Nils Leideck Senior

Re: [otrs] Stats question

t OTRS. Subject: [otrs] Stats question So I went into stats and tried to create a ticketlist report to show open tickets by tech...But either my install is broken or I'm blind since I can't find a field that shows who owns the ticket or who it's locked to. Can anyone shed some lig

[otrs] Stats question

So I went into stats and tried to create a ticketlist report to show open tickets by tech...But either my install is broken or I'm blind since I can't find a field that shows who owns the ticket or who it's locked to. Can anyone shed some light? Thank you, Jason Loven Manager - Technical Servic

[otrs] stats - know only the time taken by the user

How to know only the time taken by the user... how I can create a template of statistics to show me the average time to resolve users ticket Julio Cesar Angulo Quiroz Telf.: 997066155 - OTRS mailing list: otrs - Webpag

Re: [otrs] STATS - Ticket closed with SLA Violation

We developed it as part of our IT&Libre solution, available in spanish and english as added value to the customers that hire our ITSM consultant services. If you're interested in taking a look at it, please let us know. Leonardo Certuche www.itconsultores.com.co Medellín,

Re: [otrs] STATS - Ticket closed with SLA Violation

You develop it for own purposes or we can check it and m.b. buy rgis sytem? On 30 авг, 18:24, Leonardo Certuche wrote: > Hello there, > > I'd love to know how but true to be told, we're deploying our own reporter > web-based and with OTRS integrated authentication in which a full set of > report

Re: [otrs] STATS - Ticket closed with SLA Violation

Hello there, I'd love to know how but true to be told, we're deploying our own reporter web-based and with OTRS integrated authentication in which a full set of reports based on ITIL PKIs are shown Leonardo Certuche www.itconsultores.com.co Medellín, Colombia On 30 August 2010 03:16, Ruslan w

Re: [otrs] STATS - Ticket closed with SLA Violation

One more question - How did u getting stats using this new table "sla_times" ? On 27 авг, 18:45, Leonardo Certuche wrote: > Hello Ruslan, > > I'm glad you like it :D > > As you can see it's a workaround tropical-style. If you get the chance to > improve it or to come with a better approach, could

Re: [otrs] STATS - Ticket closed with SLA Violation

Hello Ruslan, I'm glad you like it :D As you can see it's a workaround tropical-style. If you get the chance to improve it or to come with a better approach, could you please share it with us? Thanks! Leonardo Certuche www.itconsultores.com.co Medellín, Colombia On 27 August 2010 07:04, Rusl

Re: [otrs] STATS - Ticket closed with SLA Violation

Praise you Leonardo!!! ))) And nice trick BTW ) I was trying to - rewrite module ) On 25 авг, 23:30, Leonardo Certuche wrote: > Hello, > > I'm also sad of OTRS behavior regarding SLAs. In order to save somewhere > else SLA times before they get reset, we're using the following SQL table > and

Re: [otrs] STATS - Ticket closed with SLA Violation

Hello, I'm also sad of OTRS behavior regarding SLAs. In order to save somewhere else SLA times before they get reset, we're using the following SQL table and trigger. I hope it helps and if anyone has as better approach (or if newer version won't reset those times) please let us know here. CREATE

[otrs] STATS - Ticket closed with SLA Violation

hi every one. I'm trying to create Stat-report with list of tickets closed with SLA violation. But when ticket is closed, it seems that sustem reset "escalation time" - ... I think it's wrong action. Any way - i need to analyze SLA violation in any time period. Anyone have any suggestion?

[otrs] Stats showing weird symbols

Hey there! I'm having some problems with a stat, basically is showing weird symbols were there should be an accent. My users use Spanish as a language so, a lot of words have accents. Thanks and regards María Alejandra Piedra -

Re: [otrs] Stats by ticket state

unes, 31 de Mayo de 2010 11:27 a.m. Para: User questions and discussions about OTRS. Asunto: Re: [otrs] Stats by ticket state Hi, On 31.05.2010, at 19:02, Alejandra Piedra wrote: I found out that I can make my own stat with the Static-File feature. My only question is how do I configure it, so that

Re: [otrs] Stats by ticket state

Hi, On 31.05.2010, at 19:02, Alejandra Piedra wrote: > I found out that I can make my own stat with the Static-File feature. > My only question is how do I configure it, so that once I put the file in the > //Kernel/System/Stats/Static directory, first it shows in the stats module, > and secon

Re: [otrs] Stats by ticket state

Hi Everyone! I found out that I can make my own stat with the Static-File feature. My only question is how do I configure it, so that once I put the file in the //Kernel/System/Stats/Static directory, first it shows in the stats module, and secondly it doesn't give me the following error: Can'

[otrs] Stats by ticket state

Hello! I'm trying out the new stats and I want to know if there is a way to create that account time between state changes. For example, I need to know how much time has passed from the moment the ticket is in new state to the moment it's changed to open. I know the stats use the escalations and

Re: [otrs] Stats Module Documentation??

Hi, On 25.05.2010, at 22:44, TechFan wrote: >> Open the SysConfig and go to “Framework” -> “Frontend::Agent::Stats” … there >> you will find a config option to enable an Agent name as a available part of >> your statistics within the OTRS Stat Framework … just make sure this is not >> illegal

Re: [otrs] Stats Module Documentation??

Thanks for responding! I do strongly recommend to setup searches per agent. With these searches, which you can also execute from outside of OTRS, just save them as favourites, you can keep the overview of your tickets as YOU want! That could work as long as I can track productivity of agents

Re: [otrs] Stats Module Documentation??

Hi, On 25.05.2010, at 19:41, TechFan wrote: >> First of all, we do not recommend to have a per-Agent-one-Queue concept, but >> this is Off-Topic here. > > I can understand that. The challenge was trying to have an simple way for > agents to see all the tickets they own. When using the Dashbo

Re: [otrs] Stats Module Documentation??

First of all, we do not recommend to have a per-Agent-one-Queue concept, but this is Off-Topic here. I can understand that. The challenge was trying to have an simple way for agents to see all the tickets they own. When using the Dashboard, My Queues is a really cluttered way to find your ti

Re: [otrs] Stats Module Documentation??

Hi, First of all, we do not recommend to have a per-Agent-one-Queue concept, but this is Off-Topic here. On 25.05.2010, at 17:07, TechFan wrote: > That is what a am starting with. . .but was really hoping to find some > documentation to help me understand all this. . . I am afraid there is no

Re: [otrs] Stats Module Documentation??

l not getting closed ticket notifications (though they are recorded as having been sent in the ticket history. - Original Message - From: Nils Leideck - ITSM To: "User questions and discussions about OTRS." Sent: Wednesday, May 26, 2010 7:40:32 AM Subject: [otrs] Stats Module Docu

Re: [otrs] Stats Module Documentation??

Hi, On 25.05.2010, at 09:15, TechFan wrote: > I am trying to figure out how to create some reports, but the stats module is > so powerful it is also very complex. I am trying to find some documentation > that explains how it all works. . .is there any such thing?? You can use the OTRS Adminb

[otrs] Stats Module Documentation??

I am trying to figure out how to create some reports, but the stats module is so powerful it is also very complex. I am trying to find some documentation that explains how it all works. . .is there any such thing?? - OTRS maili

Re: [otrs] Stats for Ticket Responsible

Can somebody Help me on this .. How to include Ticket responsible /Ticket Owner when taking stats (I want to know the no of calls resolved by by each agent against a week) On Tue, May 18, 2010 at 3:54 PM, Otrs User wrote: > Hi > > Can anybody Pl tell me how can I get a statistics for calls resol

[otrs] Stats for Ticket Responsible

Hi Can anybody Pl tell me how can I get a statistics for calls resolved by each agent based on Ticket Responsible and Ticket Owner field. I tried different option in Stats module , but could not locate the same. Thanks & Regards

[otrs] Stats: Ticketlist

Hello All, I did the following; 1) One week ago we changed out status model so that only "Closed" is available. (the two standard values are set to invalid) 2) Today I ran a generic agent on one queue to update the Service and SLA of historic tickets. I see fort hat queue in the updated ti

Re: [otrs] OTRS Stats : Understanding response and resolution time

Hi there, For those running into the same issue, I found out you have to set the escalation times to something else than 0 in the queue configuration screen. Else the solution times are not set and hence useless. I haven't found the way to make the response time stats work but I don't need th

[otrs] Stats by Departments

Hello everybody, I have to create states by departments, regardless of the ticket stats and queu, for example, I have two departments: Sales - with bob and alice Marketing - david and jane. I want to make a montly stats of how many tickets where issued to each department. Thanks a bunch, LOPD:

[otrs] OTRS Stats : Understanding response and resolution time

Hello, I'm having a hard time understanding the time variables available in the stats module (for dynamic-object "TicketList"') of my OTRS 2.4.7 system or finding consistent documentation about those. I got a few closed tickets and I'd like, for instance, to be able to produce a ticket list

[otrs] Stats and search results inconsistent

I am getting inconsistent results when I do an OTRS search and OTRS stats report. I am off by ONE, and I can't track down that one extra being reported. I am trying to see how many tickets were closed on February 11, 2010 in my WEB SERVICES ISSUE queue. OTRS Search query: Queue Sel

Re: [otrs] Stats

Thanks to everyone who helped with this, I downloded and installed the packages manually from search.cpan.org. Regards, This email and any attachments are confidential and are intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient of this

Re: [otrs] Stats

Hi, Here is the output: [r...@otrs ~]# perl -MCPAN -e shell Can't locate CPAN.pm in @INC (@INC contains: /usr/local/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi /usr/local/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0

Re: [otrs] Stats

Now that a GCC compiler is installed, can you please try the following: - yum install GD - *perl -MCPAN -e shell *then type Install GD And if it fails, please output what is displayed after performing the above. Regards, On Thu, Feb 25, 2010 at 1:02 PM, Guy Baxter wrote: > Thanks, >

Re: [otrs] Stats

Thanks, This has allowed the install scripts to run, but when doing a otrs.checkModules, GD is still not showing as being installed! I have restarted the OTRS service and it is still the same! Thanks. This email and any attachments are confidential and are intended solely for the use of the

Re: [otrs] Stats

yum install gcc On Wed, Feb 24, 2010 at 5:47 PM, Guy Baxter wrote: > Hi, > > Thanks for the link. I have followed them upto the make command but get an > error: > > [r...@otrs GD-2.44]# perl Makefile.PL > Notice: Type perl Makefile.PL -h for command-line option summary. > > Configuring for libgd

Re: [otrs] Stats

Hi, Thanks for the link. I have followed them upto the make command but get an error: [r...@otrs GD-2.44]# perl Makefile.PL Notice: Type perl Makefile.PL -h for command-line option summary. Configuring for libgd version 2.0.34. Checking for stray libgd header files...none found. Included Featur

Re: [otrs] Stats

Hi Guy, Have you tried installing the Perl module manually. I had to do this for a few on my fedora core install. Download http://search.cpan.org/CPAN/authors/id/L/LD/LDS/GD-2.44.tar.gz Then follow the instructions on this site : http://www.cpan.org/modules/INSTALL.html Let us know how you get

Re: [otrs] Stats

Ok, so i did a little research and I require this GD module. I ran otrs.checkModules and this is the output: [r...@otrs bin]# ./otrs.checkModules o CGIok (v3.43) o Date::Pcalcok (v1.2) o Date::Format...Not installed! (Requir

[otrs] Stats

Hi, I have OTRS 2.4.7 installed on an intel mac mini for testing. I have muddled my way through the setup of emails, users and queues quite well, but have become stuck at stats. I want to create some stats, firstly to display tickets opened in a week: Information about the Stat Stat#: 10012 Ti

[otrs] Stats by Groups - No Notification Message

Hello Everybody, I have installed OTRS 2.2.7-2lenny3, and I´m trying to make a stats by groups instead of queues. For example, I want the graph to show me how many tickets (doesn´t matter which type of queue they are in) each department has, we are a helpdesk team and we need to show monthl

Re: [otrs] Stats - Number of calls / emails before closure

Hi Leo, Followed your advise and worked for me, below is the query I used in case anyone wanted to know (ran and exported using phpMyAdmin on the machine): SELECT ticket.tn as 'Ticket Number',article.a_subject,queue.name as 'Queue',users.first_name,users.last_name,ticket.create_time,ticket_st

Re: [otrs] Stats - Number of calls / emails before closure

Hi, You could write an SQL query. All the info you're asking is stored in the article table. Each entry has the ticket_id (related to the ticket table where you find the real ticket number - tn), the article_type_id (related to the article_type table where you find the type of updates), who made i

[otrs] Stats - Number of calls / emails before closure

Hi all, How can we track the number of updates (notes, phonecalls, emails) on a ticket before it was marked closed? Thanks in advance! -- Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 This message is intended solely for the use of the original addressee(s) an

[otrs] Stats Development open / closed Tickets

Hi @ all, your personnel manager requested a stat showing the development of new Tickets compared to closed Tickets. Here an example of how it should look like: This is to determine the IT performance and new ticket development. I don't know if this is possible with OTRS Stat

[otrs] Stats module failed

I had errors when I tried to read stats. After restart of server, I tried again to read stats, the stats page was right. But after querying a stat, it was very long, and I stopped the query by stop browser button. I have two errors : =

Re: [otrs] OTRS Stats - Excluding Time Duration in X State?

Yeah I know... it was just a quick and dirty solution... then... I don't have statements ready but I know that everything may exists in ticket_history table There you have to link ticked_id, queue_id and state_id with your desired filter and compute results... On Wed, Oct 28, 2009 at 1:37 PM, Em

Re: [otrs] OTRS Stats - Excluding Time Duration in X State?

Hi Marco, Thanks for your reply, but this format doesn't give me a way to calculate time spent in each state. Plus I was really hoping to avoid reliance on excel and/or manual number crunching. Emma >>> Marco Vannini 28 October 2009 11:52 >>> Hi, For some statistics I've started to use th

Re: [otrs] OTRS Stats - Excluding Time Duration in X State?

Hi, For some statistics I've started to use the search function with the option "Result Form" to csv so my managers can manipulate data with their loved excel. This could help you ? MV On Wed, Oct 28, 2009 at 11:47 AM, Emma Williams wrote: > Does anyone know of a way to exclude any period th

[otrs] OTRS Stats - Excluding Time Duration in X State?

Does anyone know of a way to exclude any period that a ticket is in a Pending state (or any other defined state), when running a Resolution Time report? Ideally, we would like to be able to do this using the Stats module within OTRS, but failing that is there another method using SQL? ===

Re: [otrs] Stats-Module and problems with @Params

-Nachricht > Datum: Wed, 26 Aug 2009 10:26:25 +0200 > Von: "Renee Bäcker" > An: "User questions and discussions about OTRS." > Betreff: Re: [otrs] Stats-Module and problems with @Params > guenther.ra...@gmx.de schrieb: > > I´ve restarte Apache,

Re: [otrs] Stats-Module and problems with @Params

guenther.ra...@gmx.de schrieb: > I´ve restarte Apache, but still the csv-file is empty, but no > logging entry in /var/log/otrs.log anymore...! Then you have to check whether your SQL does the right thing or not ;-) Renee -- Perl-Magazin: http://perl-magazin.de Perl-Nachrichten: http://perl-na

Re: [otrs] Stats-Module and problems with @Params

"Renee Bäcker" > An: "User questions and discussions about OTRS." > Betreff: Re: [otrs] Stats-Module and problems with @Params > guenther.ra...@gmx.de schrieb: > > Hi Renee, > > > > short question, is that right (u.login = ?...): > > Yes, that&

Re: [otrs] Stats-Module and problems with @Params

guenther.ra...@gmx.de schrieb: > Hi Renee, > > short question, is that right (u.login = ?...): Yes, that's correct. I have used your module, made the changes I proposed and everything runs fine. So there seems to be another problem. Do you have replaced the old module for your installation? Doe

Re: [otrs] Stats-Module and problems with @Params

--- Original-Nachricht > Datum: Wed, 26 Aug 2009 08:31:44 +0200 > Von: "Renee Bäcker" > An: "User questions and discussions about OTRS." > Betreff: Re: [otrs] Stats-Module and problems with @Params > Petrucci schrieb: > > Hi, > > push (@Params

Re: [otrs] Stats-Module and problems with @Params

) )' Original-Nachricht > Datum: Wed, 26 Aug 2009 09:18:31 +0200 > Von: "Renee Bäcker" > An: "User questions and discussions about OTRS." > Betreff: Re: [otrs] Stats-Module and problems with @Params &g

Re: [otrs] Stats-Module and problems with @Params

Hi Guenther, you already posted the code where you defined the Variable %UserList, but that is irrelevant. The important part for the HTML form creation is what's in @Params. There you have > > push (@Params, { > Frontend => 'User', > Name => 'User', > Mul

Re: [otrs] Stats-Module and problems with @Params

}->FetchrowArray() ) { push (@Data, [...@row]); }; return ([$Title],[...@headdata], @Data); } 1; Original-Nachricht > Datum: Wed, 26 Aug 2009 08:31:44 +0200 > Von: "Renee Bäcker" > An: "User questions and discussions about OTRS."

Re: [otrs] Stats-Module and problems with @Params

Petrucci schrieb: > Hi, > push (@Params, { > Frontend => 'User', > Name => 'User', > Multiple => 0, > Size => 0, > Data => { > %UserList, > }, > > and in sub Run(): > > my $User = $Param{UserList}; > > >

[otrs] Stats-Module and problems with @Params

Hi, I´m trying to get some static statistics working. I want to select all the time an agent has accounted within a specific time. It works fine, if I don´t select the agent with this: my $Select = "SELECT ta.create_by, ta.time_unit, ta.ticket_id,

Re: [otrs] Stats to report ticket-id and its description

>From the Stats module you can click the "New" star icon and go through a four >step process to define your own reports. I believe all of the fields by >default, and any new ones defined can be selected as search criteria. Best regards, Jim ITIL Process Manager NCDOR 919-715-4932 james.b...@

Re: [otrs] Stats to report ticket-id and its description

Hi, have a look at the sourceforge project named "otrs manager" , it's verry helpfull and perhaps it can fullfill your needs. regards, Mayk - "Vijayan Thattai" wrote: > > Friends > I am looking for stats in OTRS that can give me a list of all new /closed > tickets with Ticket Id,

[otrs] Stats to report ticket-id and its description

Friends I am looking for stats in OTRS that can give me a list of all new /closed tickets with Ticket Id, and a brief description , title and owner of tickets ? Present reports only give me a total of new / closed tickets in a particular queue, however i need additional information such as who

[otrs] otrs stats first response time

Hy all, I'm knocking my head off working on : - creating a custom stat query which return for all tickets in a definied queue, the first response time. - creating a custom stat query which will return number of tickets in a definied queue who are below the first response escalation time and those

Re: [otrs] Stats error

This is not the case here. Thanks Afshar. Does anyone else have any ideas? From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Afshar Mohebbi Sent: Monday, May 11, 2009 10:54 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Stats error Hi Maurice

Re: [otrs] Stats error

rom:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of > *Maurice James > *Sent:* Wednesday, May 06, 2009 7:47 PM > *To:* 'User questions and discussions about OTRS.' > *Subject:* [otrs] Stats error > > > > I get these errors while during step 2 of tr

Re: [otrs] Stats error

Has anyone see these errors? From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Maurice James Sent: Wednesday, May 06, 2009 7:47 PM To: 'User questions and discussions about OTRS.' Subject: [otrs] Stats error I get these errors while during step 2 of trying t

Re: [otrs] stats module help welcome :-)

no clues on this ? anybody comfortable with the stat module ? Rachid On Mon, Apr 27, 2009 at 08:01:13PM +0200, Rachid Zarouali wrote: > Hy all, > i'm working once more on my otrs system and > i was trying to make a stats config which would tell me how many tickets have > their first answer in t

[otrs] Stats error

I get these errors while during step 2 of trying to create a report This was from the page Can't use string ("0") as a HASH ref while "strict refs" in use at ../..//Kernel/Modules/AgentStats.pm line 1380. This was from the system log Wed May 6 09:03:12 2009 error OTRS-CGI-10 Sta

[otrs] stats module help welcome :-)

Hy all, i'm working once more on my otrs system and i was trying to make a stats config which would tell me how many tickets have their first answer in the first response time period i've configurede in my queu config: Escalation - First Response Time: 2880 (0 = no escalation - 24 hours = 1440

[otrs] Stats. Hos to use an external field imported to MySql?

Hi all, I downloaded from another database to MySql some fields related with our customers as "Building". I want to use this information in my stats but I can not get this field. Any idea about how to get this field information in our stats? We are looking for the number of tickets by Building (We

[otrs] stats module and mkStats

Hi, We are using stats module with the help of mkStats.pl binary that allow us to generate statistics directly to a file or send it by mail, pretty useful. But I have some questions about how to pass some parameters to generate stats please ? ./bin/mkStats.pl --help mkStats.pl - OTRS cmd

[otrs] stats module

Hello Are the stats module as referred to in the manual and the package ITSMStats one and the same thing, and I have installed latter but cannot see it anywhere - not in groups or the database - yet my package manager says it is installed. I cannot see any reference to any other stats module - un

[otrs] stats report format settings

Hi, Is there a way I can adjust the various settings of the PDF report generated from the printed stats? Like the font and size, the logo? Especially the spacing in the texts bother me (see the attached example). In Core::Stats::Graph I found some but not all options. Probably a FAQ, but

Re: [otrs] Stats

Thanks Marco, it seems a very useful tool. Unfortunately, even if it shows many interesting functions, I still can not add this info imported from an external database. Cheers Raoul >did you tryed otrs-manager ? it provides some additional statistics >Aand it is GPL2 too >find it out at www dot

Re: [otrs] Stats

Den 04/12/2008 kl. 10.27 skrev Marco Vannini: did you tryed otrs-manager ? it provides some additional statistics and it is GPL2 too find it out at www dot tokaware dot com Wow, that piece of software is pretty awesome. Thank you for the link! -- Lars __

Re: [otrs] Stats

did you tryed otrs-manager ? it provides some additional statistics and it is GPL2 too find it out at www dot tokaware dot com 2008/12/3 Le machito <[EMAIL PROTECTED]>: > Hello, > I imported the list of customers from an external database. I imported some > data as name, first name, office numbe

[otrs] Stats

Hello,I imported the list of customers from an external database. I imported some data as name, first name, office number, phone, office and Department. I am trying to made stats by Department in order to know the number of request of each Department in my company. It is possible to do it with OTRS

[otrs] STATs Module

How can I generate a report in STATS to tell me turn-around time for a ticket from open to closed for metric purposes. Unless I hand create it out of SQL, there is no way to automaticly see how long a group of tickets took, such as what was the average turn-around time for all priority 1 tickets.

[OTRS] Stats Module

Hi guys I am running OTRS verson 2.0.4 and would like to customize my stats reports. The module has 4 reports, however I would like to be in a position to design my own reports. Is it possible to do this in this version because I see with OTRS 2.2.4 there is an option to create new reports. Ho

[otrs] stats

Hi I need some statistics about our ticket system but I can't make what I need. For example I need to know the average age of tickets by queues or for a time period (for a week). Has anybody done this yes? Is there any other way to make stats or only the built in 'editor'. -- Gábor Rell _

Re: [otrs] Stats reports ?

nal Message - From: Gabriele D'Andrea To: User questions and discussions about OTRS.org Sent: Tuesday, October 23, 2007 2:16 PM Subject: Re: [otrs] Stats reports ? I wrote a SQL query to do that. This one queries the database for all closed succesful tickets, calculating

Re: [otrs] Stats reports ?

I wrote a SQL query to do that. This one queries the database for all closed succesful tickets, calculating the time between creation and closing. SELECT tn, customer_id, create_time, freetime1 AS real_close_time, DATEDIFF(freetime1, create_time) AS open_days, TIMEDIFF(freetime1, create_time)

[otrs] Stats reports ?

I would like to check the performance of the sevice team. I tried to create reports, for exemple, based on difference of ticket's creation time and ticket's close time. This is not possible. Have somebody any exsperience on this issue? Agim ___ OTRS mail

[otrs] Stats reports and service performance?

I would like to check the performance of the sevice team. I tried to create reports, for exemple, based on difference of ticket's creation time and ticket's close time. This is not possible. Have somebody any exsperience on this issue? -- Agim ___ OTRS

RE: [otrs] Stats

iscussions about OTRS.org Onderwerp: [otrs] Stats Hi list! When i installed otrs, no my debian i was missing some Gdlib modules therefore my stats was not working. I have now install all modules, but i cat find anywhere to enable the stats i my otrs. How do i do this? # ./o

[otrs] Stats

Hi list! When i installed otrs, no my debian i was missing some Gdlib modules therefore my stats was not working. I have now install all modules, but i cat find anywhere to enable the stats i my otrs. How do i do this? # ./otrs.checkModules CGI ... ok Date::Pcalc .

[otrs] Stats of response per user and hour

Guys, i post a script for generate graphs with: Day: 08/27/2007 USER - 8h 9h 10h 11h 12h 13h User_1 - 3 12 13 7 514 User_2 - 8 10 21 12 910 this number is total of mails sent with system. This one form to know the yield by user/hour The post (in spanish and portu

Re: [otrs] Stats and reports

LQ Marshall wrote: I am fairly certain that 2.0.4 is a fairly old version. 2.1.x is current and 2.2 is due out soon. I can attest that 2.1.x has the stat module but not sure when it was added. Recent posts have indicated that the stat module is in it infancy. To properly evaluate OTRS yo

  1   2   >