[rt-users] billing/invoicing out of RT

[Adrian Chadd]

On Friday, November 15, 2002, at 05:08  AM, Fred Purdue wrote:

> Ladies & Gents,
>  
> One of my customers is currently using RT and loving it, but they are 
> running into a problem and are looking for a better way to handle a 
> process:
>  
> They currently keep each division in it's own queue and then they use 
> an internal billing policy to 'charge back' the costs of IT on a per 
> ticket basis.  Right now they do this by opening each resolved ticket 
> in a time period and writing down the division name, the time spent on 
> the ticket by each helpdesk staff member (different rates), and the 
> resolved date.  This is obviously pretty time consuming...  Is there a 
> better way to do this?  What is the best way to get RT to give out a 
> report that looks like this.

Have you looked at RT's schema? You might have some luck building a few
SQL queries to generate these types of totals rather than messing with 
RT
too much.



Adrian