So sorry about that last email -- my time travel machine brought me back to 2012 -- when I could have sworn I typed in 2021…
My bad. Check for the new feature in 2018 or so -- I think that was it. Now this is weird -- who invented the feature??? -John On Mon, Sep 17, 2012 at 3:56 PM, John Sundberg < john.sundb...@kineticdata.com> wrote: > > You could go into ar.cfg > > add the 2 lines : > > ars_track_long_queries: true > ars_track_long_queries_min_length: 5000 # This is milliseconds - so all > greater than 5 seconds > > > Then -- restart server > > Look for table called: "ARS_TRACK_QUERIES" (I think that is the name)… > > Look in there -- it will tell > who > when > what > how long it ran > how many entries returned > what ip address > what client type and version > > > Pretty sweet feature… (wish I would have thought of it originally) > > > -John > > > > > On Mon, Sep 17, 2012 at 10:21 AM, Chris Kelly <ctopke...@gmail.com> wrote: > >> ** >> Thanks so very much. I am not a Remedy Admin so My admin says the >> Unqualified searches is disabled. >> >> I will work on getting the fields indexed asap. >> >> The thing is we don't know who is running the queries... is there a way >> on the remedy system that we could look at to see who is running this and >> stop it when it is going on? >> >> Chris >> >> On Mon, Sep 17, 2012 at 9:09 AM, Maddala, Venkat >> <venkat.madd...@ncr.com>wrote: >> >>> ** >>> >>> Hi Chris,**** >>> >>> Here are the few things that you can do **** >>> >>> **1) **Disable Unqualified searches on server**** >>> >>> **2) **Index the most commonly used fields in search**** >>> >>> **3) **Limit the free form searches by adding custom workflow**** >>> >>> ** ** >>> >>> BTW is this for custom applications? Or OOTB?**** >>> >>> ** ** >>> >>> HTH**** >>> >>> Venkat Maddala **** >>> >>> http://RemediesForRemedy.com**** >>> >>> ** ** >>> >>> ** ** >>> >>> **** >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Chris Kelly >>> *Sent:* Monday, September 17, 2012 10:51 AM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Querys that kill my system**** >>> >>> ** ** >>> >>> ** **** >>> >>> Hello all.**** >>> >>> ** ** >>> >>> I have a question for the group.**** >>> >>> ** ** >>> >>> Our ARsystem 7.1 and what is going on is when someone runs a intensive >>> query my system comes to a standstill. what are a few things i would >>> do to stop this? or set it so if queries get approved before running???? >>> **** >>> >>> ** ** >>> >>> ** ** >>> >>> Please help ...**** >>> >>> ** ** >>> >>> Chris **** >>> >>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** >>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > > > -- > > *John Sundberg* > Kinetic Data, Inc. > "Your Business. Your Process." > *WWRUG10 Best Customer Service/Support Award* > *WWRUG09 Innovator of the Year Award* > * > * > 651-556-0930 I john.sundb...@kineticdata.com > www.kineticdata.com I community.kineticdata.com > > > > -- *John Sundberg* Kinetic Data, Inc. "Your Business. Your Process." *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"