<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 5/8/2015 3:03 PM, Armen Tashjian
wrote:<br>
</div>
<blockquote
cite="mid:BY2PR0101MB1608F53F9DC4708B68FE5F5B99DE0@BY2PR0101MB1608.prod.exchangelabs.com"
type="cite">
<defanged_meta http-equiv="Content-Type" content="text/html; ">
<defanged_meta name="Generator" content="Microsoft Word 15
(filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><DEFANGED_xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><DEFANGED_xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:12.0pt">As far
as I can see, it is not possible to search for the
resolver of a ticket. I have a single queue with
members of different groups opening and resolving
tickets. I can’t seem to figure out how to figure out
how many tickets Group 1 resolved vs Group 2. Is it
possible to run a SQL search instead of using RT’s query
language?<o:p></o:p></span></p>
</div>
</defanged_meta></defanged_meta></blockquote>
<br>
Create a Custom Field for this purpose and set it in an
OnResolved-triggered scrip, then... profit! You could perhaps also
scan transactions for the one in which the ticket resolved and pull
the actor from that transaction. In our instance, this could be RT
itself in many cases, though, since we use an autoclose status that
transitions to resolved after 72 hours via cron.<br>
<br>
Regards,<br>
Mark<br>
<pre class="moz-signature" cols="90">--
Mark D. Nagel, CCIE #3177 Emeritus <a class="moz-txt-link-rfc2396E" href="mailto:mnagel@willingminds.com"><mnagel@willingminds.com></a>
Principal Consultant, Willing Minds LLC (<a class="moz-txt-link-freetext" href="http://www.willingminds.com">http://www.willingminds.com</a>)
cell: 949-279-5817, desk: 714-495-4001, fax: 714-844-4698
** For faster support response time, please
** email <a class="moz-txt-link-abbreviated" href="mailto:support@willingminds.com">support@willingminds.com</a> or call 714-495-4000
</pre>
</body>
</html>