<html><head><base href="x-msg://10/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Christian,<div><br></div><div>While I hope that Ruslan's solution works for you - and it may be one that I implement myself. I've approached this problem differently in the past. Generally, I've viewed this issue as a management issue. As such I've developed external reports from RT that tell me how much time individuals have worked on specific queues. The SQL query I use to build these reports gives me a detailed report that I then use Excel PivotTables to provide the summaries I need.</div><div><br></div><div>Here is the SQL:</div><div><br></div><div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">SELECT t.id, t.Subject, tr.TimeTaken, tr.Created, u.Realname<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">FROM (Tickets AS t INNER JOIN Transactions AS tr ON t.id = tr.ObjectId) INNER JOIN<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> Users AS u ON tr.Creator = u.id<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">WHERE t.EffectiveId = t.id AND<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> t.Status = 'resolved' AND<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> t.Resolved >= '2010-03-01%' AND<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> (t.Status NOT LIKE '%Event%' OR t.Status NOT LIKE 'Log File%') AND<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> tr.ObjectType = 'RT::Ticket' AND<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> (tr.Type = 'Comment' OR tr.Type = 'Correspond') AND<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "> tr.TimeTaken > 0<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">ORDER BY u.RealName, t.id, tr.Created;</div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><br></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">While some of this SQL is specific to my situation (i.e. the entire " (t.Status NOT LIKE '%Event%' OR t.Status NOT LIKE 'Log File%') AND" line can be removed), the command provides all the information you will need to provide very detailed reports on Time Worked across Tickets. (NOTE in the SQL I also ONLY look for transactions with Time (i.e. tr.TimeTaken > 0) you can easily remove that line or change it to tr.TimeTaken = 0 to include Transactions in which there is no time entered.</div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><br></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Anyway... I use this report to keep my technicians in line by showing them the difference of how much work time they logged compared to actual time worked. Also, this type of analytical data is very useful during reviews, such as if a person is only accounting for 50-60% of their time, then they aren't following company policy very well.</div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><br></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">I'm sure you get the idea... and if you are looking for simple enforcement Ruslan's method looks pretty clean - as always!</div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><br></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Thanks,</div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><br></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Mike</div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; "><br></span></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; ">On Mar 15, 2011, at 8:46 AM, Pena, Christian wrote:</span></div><div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div lang="EN-US" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">This is something that has probably been asked on the lists many time so bear with me.<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">I want to make the “Worked” field mandatory on every ticket update. I read references on the need to do Call Backs but not sure what Syntax to use to achieve this. Can anyone point me in the right direction?<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">Thanks!<o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; ">Christian Pena</span></b><br><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; ">Network Engineer Supervisor</span><br><b><span style="font-size: 9pt; font-family: Verdana, sans-serif; color: rgb(223, 96, 32); ">EarthLink Business</span></b><span class="Apple-converted-space"> </span><br> <span class="Apple-converted-space"> </span><br><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; ">E:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; "><a href="mailto:christian.pena@corp.earthlink.com" style="color: blue; text-decoration: underline; ">christian.pena@corp.earthlink.com</a></span><br><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; ">O:</span></b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; "><span class="Apple-converted-space"> </span>786-363-0460 |<span class="Apple-converted-space"> </span><b>F:</b><span class="Apple-converted-space"> </span>786-363-0206</span><br><i><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: gray; ">STS Telecom is now EarthLink Business</span></i><o:p></o:p></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div></div></div></span></blockquote></div><br></div></body></html>