[rt-users] RT 4.0 - Exclude deactivated users from ajax email completion?

2011-11-18 Thread Hersker, Steve
When a user leaves, we deactivate their RT account by removing ...be granted rights as well as putting TERMINATED and the date in the Comments field. In RT 3.8, we used RTx::EmailCompletion and by removing user access RT (or ...be granted rights - to be honest, I don't remember which) it

Re: [rt-users] RT 4.0 - Exclude deactivated users from ajax email completion?

2011-11-18 Thread Hersker, Steve
When a user leaves, we “deactivate” their RT account by removing “…be granted rights” as well as putting TERMINATED and the date in the Comments field. You should mark users as disabled. Do you mean uncheck Let this user access RT? RT Training Sessions

[rt-users] What RT statistics/metrics do you report on?

2011-07-05 Thread Hersker, Steve
Not a technical issue, but I was wondering what RT stats folks report on/review periodically? For 5+ years, our RT reports consisted of exporting to an Excel spreadsheet followed by copy/paste/update of formulas/etc. Mildly time consuming but the larger issues we had were that we were unable to

[rt-users] Autocompletion of requestors - restrict to active users

2011-07-05 Thread Hersker, Steve
Is it possible to have the Ajax autocomplete of users only show Privileged users in the autocomplete field? Right now, if I type in smith, it shows all of the Smiths in RT that we've ever had. I want it to just show Smiths that ...can be granted rights. (When a user is no longer active, we

Re: [rt-users] What RT statistics/metrics do you report on?

2011-07-05 Thread Hersker, Steve
Steve, I believe the Time Worked report offered in the wiki has some of the answers for you. That code pulls up time reported from the TRANSACTION table. So whether or not a ticket is resolved bears doesn't matter, neither does the ticket owner. Anyone who reports time against a ticket creates

[rt-users] error upgrading db from 3.6.3 to 4.0.0

2011-05-02 Thread Hersker, Steve
I'm moving RT to a new server and taking the opportunity to upgrade versions as well. Currently, v3.6.3 on FC4 and MySql 4.1.16. I backed up the db with Mysqldump --opt --add-drop-table --single-transaction -default-character-set=binary -u root -pXXX rt3 rt363.adhoc.bkup Copied the SQL

Re: [rt-users] error upgrading db from 3.6.3 to 4.0.0 -- SOLVED

2011-05-02 Thread Hersker, Steve
Processing 3.7.81 DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at /opt/rt4/sbin/../lib/RT/Handle.pm line 503. Looks like you ran 3.7.81 twice DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at

[rt-users] Add/modify Username Format options?

2009-03-09 Thread Hersker, Steve
In our environment, we have users spread over 50 locations. To make it easier for the engineers, in our current 3.6.3 environment, I made a local copy of ShowUserEntry that changed: %$User-Name% % if ($User-EmailAddress $User-EmailAddress ne $User-Name)

RE: [rt-users] Unable to add the RT Activity Reports Extensions

2007-04-05 Thread Hersker, Steve
/Search/Build.html:777 /opt/rt3/share/html/autohandler:292 raw error -Original Message- From: Alan Brault [mailto:[EMAIL PROTECTED] Sent: Thursday, April 05, 2007 8:19 AM To: Hersker, Steve Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Unable to add the RT Activity Reports

RE: [rt-users] Unable to add the RT Activity Reports Extensions

2007-04-05 Thread Hersker, Steve
, though? Thanks all Steve -Original Message- From: Hersker, Steve Sent: Thursday, April 05, 2007 11:40 AM To: [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] Unable to add the RT Activity Reports Extensions Thanks, Alan - I'll check out RTx-Statistics

[rt-users] Unable to add the RT Activity Reports Extensions

2007-04-04 Thread Hersker, Steve
Hi all, I just upgraded from RT 3.6.1 to RT 3.6.3...everything went fine. While combing through the wiki, I saw the Activity Reports Extension. I downloaded the extension and installed using the steps below... Perl Makefile.PL Make install Cleared the mason cache Restarted apache

[rt-users] Date/Time format of Created (absolute)

2006-11-22 Thread Hersker, Steve
I'm using RT 3.6.1. When I perform a ticket search and include the absolute Created (or Resolved) fields, it formats the results as: day mmm dd hh:mm:ss (eg. Wed Aug 16 14:49:45 2006) Is there any way I can change that format? (For example, mm-dd- and drop the time all together?)

[rt-users] Search on Ticket Transaction custom fields

2006-10-10 Thread Hersker, Steve
Hello! I think this has been an mentioned in the past and I dug through the lists again but no luck but I may have missed it Is there a way to search for values in a custom field associated with a Ticket Transaction, not a Ticket? We track our after-hours support calls by flagging

[rt-users] Quicksearch Summary on 3.6.1

2006-08-17 Thread Hersker, Steve
Has anyone updated the Quicksearch Summary patch for v.3.6.1? (This totals the number of new, open and stalled tickets listed in QuickSearch). I put it in place for 3.4.4 and its invaluable to me to quickly see if weve got an excessive # of open tickets. Sadly, I dont have anywhere