James, You can use the Large-Result-Logging-Threshold parameter in the ar.cgf or ar.conf file. This tells the arserver to write to a log file whenever the data returned from a search exceeds the threshold that you have specified. To do this
1. Enable thread logging on the arserver. 2. Edit you ar.cfg (windows) or ar.conf (UNIX/LINUX) and add the parameter Large-Result-Logging-Threshold: <valid number> 3. Restart services or perform an arsignal. You should now see the user name and the form that was queried when the result set exceeded the threshold you set. An example of the output you get is below <THRD> /* Thu Jun 11 2009 12:07:49.2920 */ Thread Id 7144 (GLEWF) large result buffer allocation - /Length: 3271409/Entries: 15623/Client Ver: >=10/RPC ID: 2012/User: testuser1/Form: HPD:HelpDesk/ Hope this helps. Saby --- On Mon, 6/21/10, James Van Sickle <james.vansic...@cmc.com> wrote: From: James Van Sickle <james.vansic...@cmc.com> Subject: Logging form searches? To: arslist@ARSLIST.ORG Date: Monday, June 21, 2010, 6:42 PM Fellow Remedy Admins I appear to have a user that is routinely performing large queries against our Help Desk form and causing performance hits. I am trying to find a way to determine who this user is so I can educate them on how to properly query records in Remedy. What would be the best way to see the types of queries that users are making against a particular form? If I can get either the search criteria or records returned, then I could use that information to track down this user. I have tried setting up an Active Link that feeds a form when a Search action is performed. I used $LASTCOUNT$ to try and capture the number of records returned. Unfortunately, this appears to only return 0 when using it with the Search Execute On. Any assistance would be greatly appreciated. The performance hit from these searches is too random to be an Escalation. However, I have gone over Escalation workflow and logs, and not found anything that could be causing the performance hit so far. James Van Sickle Remedy Developer Commercial Metals Company _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
