Thank you very much for the info. The KB article that references this on the BMC KB is KM-000000012235.
James Van Sickle Remedy Developer Office: 972-308-4090 Mobile: 214-263-9340 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sabyson Fernandes Sent: Monday, June 21, 2010 11:29 AM To: [email protected] Subject: Re: [ARSLIST] Logging form searches? ** 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 <[email protected]> wrote: From: James Van Sickle <[email protected]> Subject: Logging form searches? To: [email protected] 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" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _____________________________________________________________________________________ This email and its attachments, if any, are intended for the personal use of the named recipient(s) and may contain confidential, privileged, or proprietary information. If you are not a named recipient, or an agent responsible for delivering it to a named recipient, you have received this email in error. In that event, please (a) immediately notify me by reply email, (b) do not review, copy, save, forward, or print this email or any of its attachments, and (c) immediately delete and/or destroy this email and its attachments and all electronic and physical copies thereof. Thank you. _____________________________________________________________________________________ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
