[rt-users] statistics

2009-04-27 Thread Aymeric Durand
Hi ; Newbie in RT, I used it since 3 months for managing tickets from users only by email. It works great. But, I search to know how extract statistics such as time to resolv ticket, average number of ticket per day . Can anyone tell me if documentation exists ? Regards ; Aymeric _

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-04-27 Thread Oleg Sladkoff
Hi , rt3 is available through EPEL repository with all dependencies... http://wiki.bestpractical.com/view/RHELorCentOSusingEPEL regards, Oleg. On Sun, 2009-04-26 at 21:49 +0100, Grant Deters wrote: > OK, got that far, has a bit of trouble with XML::RSS, however, I was > able to pull it from the

Re: [rt-users] statistics

2009-04-27 Thread ty chan
hi, you can use Query Builder in Tickets to get those report. regards, chanty From: Aymeric Durand To: rt-users@lists.bestpractical.com Sent: Monday, April 27, 2009 3:34:27 PM Subject: [rt-users] statistics Hi ; Newbie in RT, I used it since 3 months for m

Re: [rt-users] Query Builder very slow after system update

2009-04-27 Thread Tim Cutts
On 24 Apr 2009, at 3:13 pm, Liviu Costea wrote: > Hello, > > We recently updated our RT3 server ( RT 3.8.1 , around 20 > tickets) from Red Hat Enterprise Linux 5.1 to 5.3 (yum update). The > new MySQL installed version is 5.0.45. We massively sped up the Query Builder by overriding the P

[rt-users] SLA question

2009-04-27 Thread Simon Dray
RT 3.8.2 SLA 02 Dear all I hope someone can enlighten me on this I have set up in my RT_Siteconfig.pm the following but am not sure how to call it when setting up a the customfield Set(%ServiceAgreements, ( Default => 'Info', QueueDefault => { 'General' => 'Critical', },

[rt-users] Query Builder

2009-04-27 Thread Uday Dey
Hi, I am kind of novice in RT. Can someone please tell me how the query builder works? When I give the arguments and click on search how does it build the query and what all tables does it refer to Any kind of insight on this is greatly appreciated. Regards, Uday

Re: [rt-users] Migration

2009-04-27 Thread Drew Barnes
This is VERY nice to have. I will add it to the wiki so that others may reference it in the future: http://wiki.bestpractical.com/view/MigrateBugzillaToRT Javier Garcia wrote: > Hi all, > > I haven't seen this on the list so I will send the email again. > > Please find attached a short descript

[rt-users] Ticket approved... and then ?

2009-04-27 Thread L B
Hello, I'm setting up approvals on RT 3.8.2. I manage my tickets (incoming requests) in FOOBAR queue. I created a queue FOOBAR_APPROVAL for tickets needing approvals (I have a scrip/template for this queue, when I move a ticket inside, the approvers are notified and the approval process begins).

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-04-27 Thread jmoseley
Yes, I got both messages... Moving on. Next step is setting up the mysql database. 3. If you already haven't done so, set a root password for your mysql server - from a root prompt do (make sure mysqld is running): mysqladmin -u root password (don't include the <> in the actual shell command

Re: [rt-users] Upgrade RT

2009-04-27 Thread Asif Iqbal
On Tue, Nov 18, 2008 at 6:33 AM, Tim Cutts wrote: > > On 17 Nov 2008, at 10:34 pm, Asif Iqbal wrote: > > Do I upgrade from RT 3.4.5 to RT 3.8.1 directly? Or there is a roadmap >> somewhere? >> > > You can do this in almost one go, yes. It's almost exactly what I'm doing > with my production RT,

Re: [rt-users] not sending AdminCC mail to owner?

2009-04-27 Thread Drew Barnes
$NotifyActor is set to 0, perhaps as a cause? Jo Rhett wrote: > Just for clarity, I am also an admincc watcher of the queue. > > Anyone have any idea why admincc would be suppressed? > > On Apr 24, 2009, at 12:33 PM, Jo Rhett wrote: > >> I modified the default Script to send AdminCC mail to Adm

Re: [rt-users] Query Builder search on Told

2009-04-27 Thread Jo Rhett
This is a very basic SQL question. You need to go get a good book on SQL. I recommend the pink book. (you'll understand when you see it) To answer your question: IS NULL not = NULL. But please don't take my answer and fail to purchase a good book on SQL. On Apr 24, 2009, at 11:22 PM,

Re: [rt-users] RT 3.6.6 and Branded Queues

2009-04-27 Thread Jo Rhett
Um, no... just change the field in the queue configuration. This might be 3.8.x only, but it's dead simple in 3.8 On Apr 25, 2009, at 2:34 PM, Camron W. Fox wrote: > Is the only way to change 'Subject: [{$rtname} #{$Ticket->id()}]' to > 'Subject: [{$Ticket->QueueObj->Name} #{$Ticket->id

[rt-users] Reminders need explanation for checkbox (patch)

2009-04-27 Thread Jo Rhett
The Reminders page has checkboxes which are used to delete old reminders. This is the same logic as used throughout all of the pages, but apparently some users need reminders of this. The following patch solves that problem. Please consider for 3.8.3. --- html/Ticket/Elements/Reminders_o

[rt-users] EditPeople delete note inconsistent display (patch)

2009-04-27 Thread Jo Rhett
The page/element for editing People mentions the checkbox for delete, but doesn't display it consistently with other pages. It is near the top and not italicized. This patch improves the display and makes it consistent with other pages. Possible for 3.8.3 ? --- html/Ticket/Elements/EditPe

[rt-users] Help with displaying messages

2009-04-27 Thread Ken Crocker
To any and all, I want to be able to display a message on my "Modify Ticket" screen just like RT does when someone makes an error. I'd like to do it from within a scrip. Has anyone done this and can you help me with this? Thanks. Kenn LBNL ___

[rt-users] Quick Update

2009-04-27 Thread Stephen Cochran
I'm wondering if anyone has built a quick update view for RT to save us doing this. Imagine the default queue search (only new, open, or stalled) with only the following columns displayed: ID Subject Owner Status CF1 What I am hoping for is to be able to have the CF1 field displaye

Re: [rt-users] command by email failing for non RT objects

2009-04-27 Thread slamp slamp
On Sun, Apr 26, 2009 at 2:52 PM, slamp slamp wrote: > people sometimes tend to put colons on their e-mail. > > for example, > > Please see below: > > This fails command by email. Is there a way to only define a few sets > of objects to be parsed by command by email?? > > > right now we need to res

Re: [rt-users] RT 3.6.6 and Branded Queues

2009-04-27 Thread Camron W. Fox
Jo Rhett wrote: > Um, no... just change the field in the queue configuration. This > might be 3.8.x only, but it's dead simple in 3.8 > Unfortunately, upgrading to 3.8 is not an option. Camron W. Fox Hilo Office High Performance Computing Group Fujitsu Management Services of America, Inc. E-

Re: [rt-users] Auditing ticket accesses

2009-04-27 Thread Flynn, Timothy J
Jesse I think they just want to see for a particular ticket who accessed it and when. It would be nice if it was searchable and reportable so another table does make sense. But I am not sure how another table would be accessed from RT. I also liked the idea of a mutivalue custom field. For each

Re: [rt-users] RT 3.6.6 and Branded Queues

2009-04-27 Thread Ruslan Zakirov
Code in 3.8 is import of the branded queues extension into RT's core. There is even script to convert old storage into the new format. I made several tests during integration and I'm pretty sure branded queues work with RT 3.6. On Mon, Apr 27, 2009 at 8:18 PM, Jo Rhett wrote: > Um, no...  just ch

Re: [rt-users] Upgrade RT

2009-04-27 Thread Asif Iqbal
On Mon, Apr 27, 2009 at 11:19 AM, Asif Iqbal wrote: > > > On Tue, Nov 18, 2008 at 6:33 AM, Tim Cutts wrote: > >> >> On 17 Nov 2008, at 10:34 pm, Asif Iqbal wrote: >> >> Do I upgrade from RT 3.4.5 to RT 3.8.1 directly? Or there is a roadmap >>> somewhere? >>> >> >> You can do this in almost one

[rt-users] memory leaks

2009-04-27 Thread Mathieu Longtin
Hi, we have RT 3.8.1 installed with mod_perl 2.0.4 on a Red Hat ES5 system, and using Oracle as a database. I have noticed a lot of memory leaks on the part of the apache processes. It seems they grow by 2 to 5K for every page request against RT, and about 10K for every email loaded by rt-mailgat

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-04-27 Thread Grant Deters
Stupid question, but I am meerly testing this out and am not uploading this onto our domain yet.  How do I set this so it responds to http://localhost/rt thanks jmose...@corp.xanadoo.com wrote: Yes, I got both messages... Moving on. Next step is setting up the mysql database. 3. If you

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-04-27 Thread jmoseley
Unless you are using a browser on the server itself, that isn't going to work. More than likely you are using a remote browser. In that case, use the IP address of the server, or better yet the FQ host name: http://10.10.10.10/rt/or http://server.domain.com/rt/ Obviously for the latter to w

[rt-users] How to grant LDAP user

2009-04-27 Thread nast linux
Dear All, How to grant user on Active Directory server as Ticket Creator? And how to assgin them to queues? Could you give the references. I have not found them yet at rt documentation. Thanks, ns ___ http://lists.bestpractical.com/cgi-bin/mailman/lis