[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 would prevent that user from showing up in the java script for email
completion but would still show their name as a Requestor on the Ticket
Display. 

 

In RT 4.0, if we remove ...user can access RT, they no longer show up
in the email completion however they also don't show up as the Requestor
of any of their tickets. (Not good for historical reasons)

 

Is there a way to keep them from showing in email completion but still
allow them to show as Requestors? Via RT_SiteConfig you can compare
against whatever fields you'd like but I'm looking for a way to exclude
users based on something not entered in the email field. (eg if Commets
STARTSWITH Terminated).

 

I'm thinking it's a permissions issue in how we have RT configured. I
gave Unprivileged users the Sign up as a ticket Requestor and they
show as ticket Requestors but still also show up in the email
completion.

 

If anyone has any hints, suggestions, solutions, workarounds, etc, I'd
appreciate it!

 

Thanks

Steve

 


RT Training Sessions (http://bestpractical.com/services/training.html)
*  Barcelona, Spain — November 28  29, 2011

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 (http://bestpractical.com/services/training.html)
*  Barcelona, Spain  November 28  29, 2011

[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
report stats based on a user's Organization and we were unable to get a
lot of detail on a per-engineer basis. 

When we upgraded to RT 4.0, I took the opportunity to add a couple of
custom fields and wrote a Perl script to extract and report on various
metrics instead of using Excel. This allows us to now report on
Division/Site (stored in the Organization field) and get more detail for
each support engineer.

For example, we report monthly on the following (both overall and per
support engineer):
Tickets Created
Tickets Resolved
Hours recorded  % of hours recorded (based on business days in month)
Average minutes per ticket
% Submitted via Phone
% Submitted via Email 
Average days to resolve
Resolved Same Day 
Resolved Next Day
Resolved two or more days
  [A note on the Resolved calculations: I use date::manip to calculate
business days instead of calendar days. Eg a ticket comes in at 4:30pm
on Friday and is resolved by 9:00am Monday, that's resolved - same day
- within 8 business hours. The old Excel reports would show that as
resolved in 3 days, which to me wasn't fair.]

Ticket count, hours and Avg min/ticket (% and total for each) for 
- Ticket Type (Issue, Request or Project)
- Ticket Category (problem category and topic, eg. Workstation and
then within that Application install/fix, hardware repair/upgrade,
OS fix/rebuild, etc)
- Division

Then, Top Five by both ticket count and time recorded:
- Category / Topic
- Site

One small issue is that ticket time is only allocated to the Owner of
the ticket. So, if someone records 2 hours of time on a ticket they
don't own, they don't get credit for it. But, in our group that's a
fairly small occurrence. Also time recorded is only reported on
tickets that were Resolved the previous month. So, if an engineer logged
40 hours on a ticket but didn't resolve it yet, that time doesn't show
up until the next month (or whenever they resolve the ticket). I'd
rather see actual time recorded in a month but, again, not yet worth the
effort to adjust the report, especially since the time shows up sooner
or later.
 
One stat I'd like to add soon is Average Minutes per User (per Site).
For example, if we have Site A with 50 users and Site B with 5 users and
both have 10 hours of time, that might not stand out in the Top Five
but would in Minutes/User, prompting me to wonder and research why we
spend 10x more support for the smaller site etc.

I realize with RT's infinite flexibility, there are a great many ways to
use it. But, I am curious to see what else anyone might report on?

Thanks!
Steve




2011 Training: http://bestpractical.com/services/training.html


[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 uncheck Let this user be
granted rights. This still allows the inactive user's name to appear in
searches and ticket details.

 

Thanks,

Steve



2011 Training: http://bestpractical.com/services/training.html

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 a record in t he transaction file.  Sooo, you might want to
look at that code and borrow some of it for your own purposes.

 Kenn
 LBNL


Thanks, Kenn! I'll take a look at that!
Steve


2011 Training: http://bestpractical.com/services/training.html


[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 dump to the new server running CentOS 5.5 and MySql 5.0.77 and 
restored the RT3 db.

Last week, I successfully upgraded from 3.6.3 to 3.8.9 (patched the db to 
3.7.87, applied the 3.8.0 schema changes, patched the database up to 3.8.9 as 
per UPGRADING.mysql). Worked great, no problems. Was just about to implement 
that when RT 4.0.0 was released...

SoI want to upgrade to that instead. There was no UPGRADING.mysql, just the 
README saying to run rt-setup-database.

When I try to upgrade from 3.6.3 all the way up to 4.0.0, I'm getting:
Processing 3.7.81
Now populating database schema.
[Mon May  2 20:53:58 2011] [crit]: DBD::mysql::st execute failed: Duplicate key 
name 'CachedGroupMembers3' at /opt/rt4/sbin/../lib/RT/Handle.pm line 503. 
(/opt/rt4/sbin/../lib/RT.pm:340)
DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at 
/opt/rt4/sbin/../lib/RT/Handle.pm line 503.


Since the 3.8.9 upgrade worked fine (with the included schema change queries), 
I used rt3.8.9 to upgrade my 3.6.3 to 3.8.9 (again, going to 3.7.87, applying 
the schema change queries, then upgrading the db to 3.8.9). Which, again, 
worked fine.

Then, using RT 4.0.0, I tried to update the database from 3.8.9 to 4.0.0 and am 
getting the error:
Processing 3.9.3
Now populating database schema.
[Mon May  2 20:31:51 2011] [crit]: DBD::mysql::st execute failed: Can't DROP 
'DelegatedBy'; check that column/key exists at 
/opt/rt4/sbin/../lib/RT/Handle.pm line 503. (/opt/rt4/sbin/../lib/RT.pm:340)
DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key 
exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 503.

Do I need to upgrade incrementally from 3.6.3 to 3.8.9 to 3.9.x and then to 
4.0.0? Is there info on this that I missed? Or, should the rt-setup-database 
handle the jump from 3.6.3 to 4.0.0 (including 3.8.0's schema changes)?

(I'm not a SQL expert in the least).

Thanks for any help!
Steve


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
 /opt/rt4/sbin/../lib/RT/Handle.pm line 503.
 
 Looks like you ran something else twice too, since that column has
 existed since at least 3.4

Yep, self-inflicted for sure...was trying to figure out how I ran twice when I 
realized that I had restored the db to the new box and called it rt3 AND when I 
did a fresh install of RT4.0.0 I had also initialized the database (to make 
sure everything was working before dealing with the data). So when I was 
running rt-setup-database, it was running against the rt4 database, which of 
course was already current, not the rt3 that I had restored. 

 You can use rt-setup-database from 3.6.3 to 3.7.81 follow
 UPGRADING.mysql and then continue onward from there to 4.0.0

I dropped the blank rt4 db, renamed my rt3 db to rt4 and ran through the steps 
above and it worked perfectly.

Thanks, Kevin!!




[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)
{lt;%$User-EmailAddress%gt;

 

to be:

 

%$User-RealName%

% if ($User-EmailAddress  $User-EmailAddress ne $User-Name)
{lt;%$User-Organization%gt;

 

so that the Ticket meta data it would show Last, First Organization
(saving us from having to memorize everyone's first name and their
location).

 

I'm testing 3.8.2 now and see that there's now a preference per-user
regarding displaying the Username Format. The only choices are Short
Names or Name and Email Address.

 

The code providing the per-user preference setting of how to display
user names completely eclipses my rudimentary perl skills. Can anyone
point me in the right direction on how to add my own format selections
to this preference? (I'd like to add Short Name and Organization.)

 

Thx

Steve

 

 

 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

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

2007-04-05 Thread Hersker, Steve
Thanks, Alan - I'll check out RTx-Statistics.

Unfortunately, this morning I found that when I run a search, I get the errors 
below. At this point, can someone point me in the right direction as to how to 
best remove the RTx-Activity report extension altogether?

Thanks!!
Steve


error:  Error during compilation of 
/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions:
Can't locate YAML.pm in @INC (@INC contains: /opt/rt3/local/lib /opt/rt3/lib 
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 
/usr/lib/perl5/site_perl 
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/5.8.6 . /etc/httpd) at 
/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions 
line 3.

Stack:
[/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions:3]
[YAML.pm:3]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:792]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:422]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1092]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1023]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1202]
[/opt/rt3/share/html/Elements/Callback:83]
[/opt/rt3/local/html/Search/Results.html:93]
[/opt/rt3/share/html/Search/Build.html:777]
[/opt/rt3/share/html/autohandler:292]
BEGIN failed--compilation aborted at 
/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions 
line 3.

Stack:
[/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions:3]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:792]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:422]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1092]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1023]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1202]
[/opt/rt3/share/html/Elements/Callback:83]
[/opt/rt3/local/html/Search/Results.html:93]
[/opt/rt3/share/html/Search/Build.html:777]
[/opt/rt3/share/html/autohandler:292]

 
context:  1:  a href=% $RT::WebPath %/Reports/Activity/index.html?% 
$QueryString %Generate reports/a 
2:  %init 
3:  use YAML; 
4:  my %args = $m-caller_args(2); 
5:   
6:  my $QueryString = $m-comp('/Elements/QueryString', query = $args{Query}); 
7:  /%init 
...   
 
code stack:  /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:426
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1092
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1023
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1202
/opt/rt3/share/html/Elements/Callback:83
/opt/rt3/local/html/Search/Results.html:93
/opt/rt3/share/html/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 Extensions

Steve:

I had the same problem with RT 3.6.3 and that particular extension. I would 
recommend you use RTx-Statistics instead as that is a far better extension and 
works like a charm with 3.6.3.

You can download it at:

http://wiki.bestpractical.com/index.cgi?RT3StatisticsPackage

--
Regards,

Alan Brault
UNIX  Web Applications Developer
Hardware and Tools Corp

On Thu, 2007-04-05 at 00:44 -0400, Hersker, Steve wrote:
 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
 
 Restarted my browser
 
  
 
 But, I don’t see the extensions anywhere…I’m “assuming” that the 
 Activity reports should be under the Tools / Reports menu, but it’s 
 not there. Am I looking in the wrong place or did I miss a step?
 
  
 
 Also, what’s the cleanest way to uninstall the extension at this 
 point?
 
  
 
 Thx!
 
 Steve
 
  
 
 I was able to install the Service Updates and Timeline extensions 
 without any problems and both are working fine.
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com Commercial support

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

2007-04-05 Thread Hersker, Steve
Forget the error messageI was scrolling to the bottom when I should have 
just looked at the 3rd line down...I installed YAML and searches run clean now.

The Activity report formatting is pretty rough so I'm going to give 
RTx-Statistics a shot as Alan suggests. How do I remove RTx-Activity, 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.

Unfortunately, this morning I found that when I run a search, I get the errors 
below. At this point, can someone point me in the right direction as to how to 
best remove the RTx-Activity report extension altogether?

Thanks!!
Steve


error:  Error during compilation of 
/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions:
Can't locate YAML.pm in @INC (@INC contains: /opt/rt3/local/lib /opt/rt3/lib 
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 
/usr/lib/perl5/site_perl 
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/5.8.6 . /etc/httpd) at 
/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions 
line 3.

Stack:
[/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions:3]
[YAML.pm:3]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:792]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:422]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1092]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1023]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1202]
[/opt/rt3/share/html/Elements/Callback:83]
[/opt/rt3/local/html/Search/Results.html:93]
[/opt/rt3/share/html/Search/Build.html:777]
[/opt/rt3/share/html/autohandler:292]
BEGIN failed--compilation aborted at 
/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions 
line 3.

Stack:
[/opt/rt3/share/html/Callbacks/ActivityReports/Search/Results.html/SearchActions:3]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:792]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:422]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1092]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1023]
[/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1202]
[/opt/rt3/share/html/Elements/Callback:83]
[/opt/rt3/local/html/Search/Results.html:93]
[/opt/rt3/share/html/Search/Build.html:777]
[/opt/rt3/share/html/autohandler:292]

 
context:  1:  a href=% $RT::WebPath %/Reports/Activity/index.html?% 
$QueryString %Generate reports/a 
2:  %init 
3:  use YAML; 
4:  my %args = $m-caller_args(2); 
5:   
6:  my $QueryString = $m-comp('/Elements/QueryString', query = $args{Query}); 
7:  /%init 
...   
 
code stack:  /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Interp.pm:426
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1092
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1023
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1202
/opt/rt3/share/html/Elements/Callback:83
/opt/rt3/local/html/Search/Results.html:93
/opt/rt3/share/html/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 Extensions

Steve:

I had the same problem with RT 3.6.3 and that particular extension. I would 
recommend you use RTx-Statistics instead as that is a far better extension and 
works like a charm with 3.6.3.

You can download it at:

http://wiki.bestpractical.com/index.cgi?RT3StatisticsPackage

--
Regards,

Alan Brault
UNIX  Web Applications Developer
Hardware and Tools Corp

On Thu, 2007-04-05 at 00:44 -0400, Hersker, Steve wrote:
 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
 
 Restarted my browser
 
  
 
 But, I don’t see the extensions anywhere…I’m “assuming” that the 
 Activity

[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

Restarted my browser

 

But, I don't see the extensions anywhere...I'm assuming that the
Activity reports should be under the Tools / Reports menu, but it's not
there. Am I looking in the wrong place or did I miss a step?

 

Also, what's the cleanest way to uninstall the extension at this point?

 

Thx!

Steve

 

I was able to install the Service Updates and Timeline extensions
without any problems and both are working fine.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[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?)

Thanks
Steve

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


[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 the Ticket
Transaction as No, Yes (Emergency), Yes (non-emergency). Id prefer to
keep it on the Ticket Transaction level because we may continue working on a
particular issue during regular hours. So, perhaps 30 minutes was after hours
but we continued and resolved the ticket after another 60 minutes during business
hours. I need to report the 30 minutes, not the total 90 minutes.



Depending on the responses to this, Ill likely just
have to move the custom field up to the Ticket level and advise my engineers
that if its not resolved after hours, theyll need to open a new
ticket for the business hours portion and reference the other
ticket.



Does anyone have any suggestions for handling this better?
(The goal being to report to mgmt the # of and time worked for after hours
support calls).



Thanks

Steve








___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[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 near the skills needed to
update this myself.



Thanks!

Steve








___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com