<html><body><div style="font-family: Arial; font-size: 10pt; color: #000000"><div>Hello,</div><div><br></div><div>I hope I am able to explain what I want well enough for you to help me out. Many thanks in advance.<br></div><div><br></div><div>I am running RT 4.2.1 on Ubuntu 12.04 and Mysql, with SLA, Captcha Extensions.<br></div><div><br></div><div>What I want to achieve:<br></div><div><br></div><div>Query RT for the amount of TimeWorked in a given month for a given queue.<br></div><div><br></div><div>This query: Queue = 'Chase' AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' OR Status = 'resolved' ) AND TimeWorked > 0</div><div><br></div><div>gives me the data I want, but now I want to filter it down to work out how much TimeWorked accrued between a given set of date/times. E.g. between 1st of the Month at 0 oclock and the 30th of the month at 23.59 oclock.<br></div><div><br></div><div>Please note that I DO NOT want any TicketCreated stuff. Some of our tickets run for VERY long periods of time, and they might accrue TImeWorked over a period of many months. I want to extract the TimeWOrked for a given month for all tickets regardless of status and creation date/time.<br></div><div><br></div><div>Ultimately i hope to build a monthly dashboard that can easily report this.<br></div><div><br></div><div>Many thanks for your help.<br></div><div><br></div><div>Alex<br></div><div><br></div><div>-- <br></div><div><span name="x"></span><div><strong>Alex Rhys-Hur</strong><span style="font-weight: bold;">n </span>| <span style="font-weight: bold;">ITworX Limited</span><br>P.O. Box 1649, 00502, Karen, Kenya<br>Tel: +254 (0) 20 2444824 | Cell: +254 (0) 724 972541<br>Web: <a href="http://www.itworx.co.ke">www.itworx.co.ke</a><br></div><div><br></div><div><u><img doc="Briefcase/webmail_logo.png" src="cid:a4f4fc65f747a899759bf428bd8bcc0eae418f8a@zimbra" style="width: 135px; height: 62px;"><br></u><br></div><div><br></div><span name="x"></span><br></div></div></body></html>