<HTML dir=ltr><HEAD><TITLE>Re: [rt-users] Logging query terms in RT</TITLE>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19154"></HEAD>
<BODY>
<DIV dir=ltr id=idOWAReplyText59141>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>Thanks for the response, DB logging might be the way I have to go. </FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>Oddly, StatementLog doesn't log anything when submitting a query from Query Builder. Doesn't even log that the database was hit at all.</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>I was equally curious about this!</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>-Guy</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> rt-users-bounces@lists.bestpractical.com on behalf of Kevin Falcone<BR><B>Sent:</B> Wed 16/11/2011 16:57<BR><B>To:</B> rt-users@lists.bestpractical.com<BR><B>Subject:</B> Re: [rt-users] Logging query terms in RT<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>On Wed, Nov 16, 2011 at 10:42:05AM -0000, Jeffery, Guy wrote:<BR>><BR>> Hi,<BR>><BR>> I'm supporting an instance of RT, and have a requirement to log all queries made in RT by our<BR>> users, including all terms used to create the query.<BR>><BR>> I can capture the terms used in Simple Searches as part of a POST request within the Apache<BR>> logs, so that problem is solved.<BR>><BR>> But I can't find any mechanism for logging the terms used to build more complex queries in the<BR>> Query Builder. I've turned on the Statement log, and all other logging, at 'info' level.<BR>> However, RT still doesn't capture the information I need. The only place I've found this<BR>> information stored at all is within the a_session longblob in the sessions table on the<BR>> database - but it's not that nice to extract the individual terms from that. I've also looked<BR>> on the Wiki and the forums without luck.<BR><BR>This would be easier to do at the database level. It'll be too many<BR>queries, but StatementLog will log too many queries also.<BR><BR>I'm curious why StatementLog isn't sufficient.<BR><BR>-kevin<BR></FONT></P></DIV>
</BODY></HTML>
<pre>Please consider the environment before printing this email.
This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy by an authorised signatory.
The contents of this email may relate to dealings with other companies under the control of BAE Systems plc details of which can be found at http://www.baesystems.com/Businesses/index.htm.
Detica Limited is a BAE Systems company trading as BAE Systems Detica.
Detica Limited is registered in England and Wales under No: 1337451.
Registered office: Surrey Research Park, Guildford, Surrey, GU2 7YP, England.