<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=SV link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Maybe you can use this report?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><a href="http://wiki.bestpractical.com/view/TimeWorked">http://wiki.bestpractical.com/view/TimeWorked</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>/Johan<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>John Constable<br><b>Sent:</b> den 11 oktober 2010 12:56<br><b>To:</b> rt-users@lists.bestpractical.com<br><b>Subject:</b> [rt-users] getting 'time worked' for one user and one time period<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-GB>Hi all,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>Hoping someone else has done this already I can crib from..<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>Our team uses RT for trouble tickets, and record how much time they spend on each update. They also pass tickets among themselves. I run a very basic report of tickets modified that week in that queue, and, downloading the spreadsheet, calculate the time worked field for each owner. This has a number of problems, the most pertinent of which is that it seems to show all the time worked, and hence that users may ‘benefit’ from work on the ticket by others but its applied to just their userid, and there is no way to extract just the time worked in that week.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>Has anyone done this in a more elegant, accurate way? I’m happy to write some code to do this, but was wondering if RT stores the data for time in a (say) array for each ticket, or just an incremented counter, which would mean I could never separate the ticket out between the multiple contributors, or times contributed.. Some advice would be appreciated!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>Cheers<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>John<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>--<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>John Constable<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>Group IT Manager<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>ip.access Ltd<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>DDI: +44 1954 713723<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>Don't forget IT On call No: +44 1954 717909<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>Please raise all IT issues via <a href="mailto:ITS@ipaccess.com">ITS@ipaccess.com</a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br><br><o:p></o:p></span></p><p><span lang=EN-GB>This message contains confidential information and may be privileged. If you are not the intended recipient, please notify the sender and delete the message immediately.<o:p></o:p></span></p><p><span lang=EN-GB>ip.access ltd, registration number 3400157, Building 2020, <br>Cambourne Business Park, Cambourne, Cambridge CB23 6DW, United Kingdom<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div></div></body></html>