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?
Thanks in advance.
-Armen
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?
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.
Regards,
MarkMark D. Nagel, CCIE #3177 Emeritus mnagel@willingminds.com
Principal Consultant, Willing Minds LLC (http://www.willingminds.com)
cell: 949-279-5817, desk: 714-495-4001, fax: 714-844-4698
** For faster support response time, please
** email support@willingminds.com or call 714-495-4000