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"
