I think that was in version 5.1.2 Regards, Jarl
2010/6/22 LJ LongWing <lj.longw...@gmail.com> > ** > > Well I’ll be….never knew about that option….when did it get introduced? > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Sabyson Fernandes > *Sent:* Monday, June 21, 2010 10:29 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: 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 <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" > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _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"