[otrs] administrator approval for customer self-created accounts

2005-01-26 Thread m
I would like to use the self-creation of customer accounts feature, however, I'd like to also require Administrator approval before the account is created. In addition, I want to set the customer number and perhaps even the username myself before the system sends out the password. Is this possibl

[otrs] Question about actions on Queues and subqueues

2005-01-26 Thread m
If I want to check the status of a ticket in a queue and its subqueus, such as: Active Active:Senior Technicians Active:Junior Technicians Active:Supervisor Can I merely specify the queue as "Active"? That is to ask: when specifying a queue, are all subqueues included in a search?

[otrs] what variable do I use?

2005-01-26 Thread m
I want to reset the escalation time on tickets after they are answered, such that, when a ticket is answered, the escalation timer will restart based on the escalation time for whatever queue has the ticket. Once the ticket escalates, I already move the ticket to a new queue. I also want to reset

RE: [otrs] Changing default priority based on CustomerUser data?

2005-01-26 Thread Peter van Beugen
Maybe this will do: http://sourceforge.net/mailarchive/forum.php?thread_id=3141440&forum_id=2347 Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter van Beugen Sent: woensdag 26 januari 2005 23:18 To: User questions and discussions about OTRS. Sub

RE: [otrs] Changing default priority based on CustomerUser data?

2005-01-26 Thread Peter van Beugen
I would write a separate simple POP3 program, which POPs the e-mails first, check the e-mail adress on your specific customer database, looks up the priority indication in the database and send/forward the e-mail according to this priority to a specific (OTRS) e-mail address ([EMAIL PROTECTED]/[

RE: [otrs] Stats for average Agent response time?

2005-01-26 Thread Peter van Beugen
Charles, We use CF as well. Will you send me your CF pages that produce these Stats? Regards, Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles R. Thompson Sent: woensdag 26 januari 2005 19:04 To: 'User questions and discussions about OTRS.

Re: [otrs] Stats for average Agent response time?

2005-01-26 Thread Edgar Meij
whoops, sorry Charles, missed your post :-)... On Wed, 26 Jan 2005 21:28:14 +0100, Edgar Meij <[EMAIL PROTECTED]> wrote: > Yes, one can, but it's not that easy :-). You can try and query the > SQL database with the proper commands. I'm actually working on a > (small) perl script myself, doing jus

Re: [otrs] Stats for average Agent response time?

2005-01-26 Thread Edgar Meij
Yes, one can, but it's not that easy :-). You can try and query the SQL database with the proper commands. I'm actually working on a (small) perl script myself, doing just that. It's not quite finished yet though... hth, Edgar Meij On Wed, 26 Jan 2005 07:48:16 -0800, Wes Plate <[EMAIL PROTECTED]

RE: [otrs] Stats for average Agent response time?

2005-01-26 Thread Charles R. Thompson
I use ColdFusion to tap into OTRS and built charts/graphs, etc. and have learned the secret to reporting on tickets lies in understanding the interaction of the following tables TICKET TICKET_HISTORY TICKET_HISTORY_TYPE TICKET_STATE TICKET_STATE_TYPE Using somehting like PHPMyAdmin I would recomm

[otrs] Stats for average Agent response time?

2005-01-26 Thread Wes Plate
Is there a way to get from OTRS the average time it takes for an Agent to respond to a new ticket? -- Wes Plate Automatic Duck, Inc. http://www.wesplate.com http://www.automaticduck.com ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ A

Re: [otrs] more from Stats

2005-01-26 Thread Alvaro Lopez
Yes, Greger, I've this files in this. But I copy TicketOverview.pm as Ticket_Overview.pm But I don´t know where I may say to OTRS that load this .pm file. Simply add the following lines to your Config.pm $Self->{SystemStatsMap}->{"OTRS::Stats6"} = { Name => 'Test Stats Module',

RE: [otrs] Changing default priority based on CustomerUser data?

2005-01-26 Thread Jack Doyle
How else would you do it then? What kind of way are you thinking about? - Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems -Original Message- From: Talley, Brooks [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 7:22 PM To: User ques

RE: [otrs] more from Stats

2005-01-26 Thread Markus Ruecker
Hi, > Yes, Greger, I've this files in this. But I copy > TicketOverview.pm as Ticket_Overview.pm But I don´t know > where I may say to OTRS that load this .pm file. Simply add the following lines to your Config.pm $Self->{SystemStatsMap}->{"OTRS::Stats6"} = { Name => 'Test Stats Mo

Re: [otrs] more from Stats

2005-01-26 Thread Alvaro Lopez
- Where is generate the SQL query (location). - Where is list the stats generates. The stats modules are in the Kernel/System/Stats/*.pm location, if not there then cvs co the latest from cvs.otrs.org, and you'll have them. Yes, Greger, I've this files in this. But I copy TicketOverview.

Re: [otrs] more from Stats

2005-01-26 Thread greger
> > > Hello all, again :) > > I'm looking in archives (aorund an hour), but I can´t found > nothing about my question, it's right that many people ask about stats, > but I need to know only 3 things: > > - Where is generate the SQL query (location). > -

[otrs] more from Stats

2005-01-26 Thread Alvaro Lopez
Hello all, again :) I'm looking in archives (aorund an hour), but I can´t found nothing about my question, it's right that many people ask about stats, but I need to know only 3 things: - Where is generate the SQL query (location). - Where is list the st

Re: [otrs] Stats

2005-01-26 Thread Alvaro Lopez
No, I need to change it in Linux. I work under Debian and the server running in Debian. But for jobs policy in my host I've got the fucking Windows :). But the OTRS is installed under Debian. But if I can understand what you say (my english is poor... ), you have 3 admin accounts to print

Re: [otrs] Stats

2005-01-26 Thread Alvaro Lopez
Hello Alvaro, I can write a stats module for you, but depends on what type of stats you are interested in. Please tell me more in detail please. thank's Greger Thanks Greger, but I need to know how can I do it. becuase at this moment I only have 4 stats, but be sure that when my head know th