<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>Dear RT Users,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am trying to find/create a report from RT that
outputs the total time recorded in RT across all queues for each user each day.
In other words, I would like to be able to produce <SPAN
class=389494820-20092006>a report </SPAN>that looks something like
this:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>User<SPAN
class=389494820-20092006>1</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> 20 September
2006</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> Ticket
#1223 0.5 hours</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> Ticket
#1245 0.2 hours</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> Daily total 0.7
hours</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> 21 September
2006</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> Ticket
#1246 0.6 hours</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> Daily total 0.6
hours</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=389494820-20092006>User1
Total 1.1 hours</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006>===</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006>User2</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006> 20 September
2006</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006></SPAN></FONT></FONT><FONT face=Arial><FONT
size=2><SPAN class=389494820-20092006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=389494820-20092006>...and so on.
The actual order of the grouping doesn't matter a great deal, and in fact the
detail lines are also not essential, but I do need to have the daily totals from
all the queues for each user.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=389494820-20092006>I have taken
the code from the RT3StatisticsPackageTimeWorked page on the wiki, I think it
might be quite close to what I need but so far I haven't been able to get it to
work - the code is quite old and according to the developer it was not written
for my version of RT (3.4.5). I have got to the point where the report will run
without errors but the report is empty. I am not a Perl guy so I'm facing a big
learning curve trying to debug this code. </SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=389494820-20092006>Has anyone
created such a report? Or something like it? Any help would be appreciated
-either creating a new report or getting RT3StatisticsPackageTimeWorked running.
Results would go back to the wiki.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006></SPAN></FONT></FONT> </DIV>
<DIV align=left><FONT><FONT face=Arial><FONT size=2><SPAN
class=389494820-20092006>Thanks</SPAN>,</FONT></FONT></FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Rob Rowland</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>DirectnetIT</FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>