Re: [rt-users] Searching For Tickets Without Reminders

2014-01-07 Thread Christian Loos
Am 02.01.2014 22:33, schrieb Ram: Hey there, We handle a bunch of tickets and one of the ways we help our support staff not drop the ball is by putting a saved search on the support Dashboard that shows 'my stagnant tickets' [LastUpdated '12 days ago' AND Owner.id = '__CurrentUser__' AND

[rt-users] Untake/Set owner of other users' tickets

2014-01-07 Thread Oriol Soriano
Hi, In our work team, we have regular members and team managers. I would like to enable team managers to 'untake' other members tickets (eg: to tweak workload). I would preffer only team managers having this right. But, at this point, Im not being able to spot a right to enable this work

[rt-users] Ned help for RT ticketsql

2014-01-07 Thread Jack Liu
Hi, We are using RT 3.6.1. need create rt command line to find ticket created old than 3 hours ago. That should be easy as: /usr/bin/rt list -t ticket id=37679 and Created'-180 minutes' But the user need add some pending time to ignore, so I did try to create one custom field to

[rt-users] Unused Scripts

2014-01-07 Thread Bryon Baker
Hello all what is the best way to delete unused scrips. It would be easy to delete the entries in the database. Is the acceptable? Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 * 262-783-6261 ext. 2296

Re: [rt-users] Unused Scripts

2014-01-07 Thread Bryon Baker
I have them disabled but I just want to obliterate them I am never going to use them. I have replace a lot of the original scripts with custom action scrip. So I can also run them as cron jobs. Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726

Re: [rt-users] Unused Scripts

2014-01-07 Thread Kenneth Crocker
Bryon, Why not just disable them? Kenn Sent from my Windows Phone -- From: Bryon Baker bba...@copesan.com Sent: 1/7/2014 9:50 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] Unused Scripts Hello all what is the best way to delete unused scrips.

Re: [rt-users] Untake/Set owner of other users' tickets

2014-01-07 Thread Kevin Falcone
On Tue, Jan 07, 2014 at 03:22:04PM +, Oriol Soriano wrote: In our work team, we have regular members and team managers. I would like to enable team managers to `untake' other members tickets (eg: to tweak workload). I would preffer only team managers having this right.

Re: [rt-users] Ned help for RT ticketsql

2014-01-07 Thread Kevin Falcone
On Tue, Jan 07, 2014 at 12:46:24PM -0500, Jack Liu wrote: I also tried to put Pending ignore second in a field, but have no way to make this work for rt 3.6.1 /usr/bin/rt list -t ticket id=37679 and Created '-180 minutes' + CF.{IgnoreTime} Are you trying to add the time

Re: [rt-users] Searching For Tickets Without Reminders

2014-01-07 Thread Ram
One of the users asked if we can modify the 'my stagnant tickets' search to omit tickets that have an open reminder set. This seems like a reasonable approach. Anyone know how to do this using RT Ticket Searches? You can create a ticket CustomField 'has_open_reminder' and create an

[rt-users] Encrypting the DB password in RT_Siteconfig

2014-01-07 Thread Brent Wiese
Is there a way to use an encrypted value for $DatabasePassword in RT_Siteconfig? Thanks, Brent

Re: [rt-users] Encrypting the DB password in RT_Siteconfig

2014-01-07 Thread k...@rice.edu
On Tue, Jan 07, 2014 at 09:36:03PM +, Brent Wiese wrote: Is there a way to use an encrypted value for $DatabasePassword in RT_Siteconfig? Thanks, Brent Hi Brent, DBD::Pg uses the libpq library, which supports GSSAPI. You could use that for your authentication instead -- at least if

Re: [rt-users] Encrypting the DB password in RT_Siteconfig

2014-01-07 Thread Brent Wiese
On Tue, Jan 07, 2014 at 09:36:03PM +, Brent Wiese wrote: Is there a way to use an encrypted value for $DatabasePassword in RT_Siteconfig? Thanks, Brent Hi Brent, DBD::Pg uses the libpq library, which supports GSSAPI. You could use that for your authentication instead -- at

Re: [rt-users] Encrypting the DB password in RT_Siteconfig

2014-01-07 Thread Alex Vandiver
On Tue, 2014-01-07 at 21:36 +, Brent Wiese wrote: Is there a way to use an encrypted value for $DatabasePassword in RT_Siteconfig? What, exactly, do you mean by encrypted? RT clearly needs to have access to the plaintext password to pass to the MySQL authentication process, so there is