Thanks for the idea Frank.. I will try that. I need to run a SQL log to find the table in the db.
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Friday, August 06, 2010 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: query on priority change ** If you have auditing turned on for that field you might be able to link into the audit table for that form and extract out any prior values. On Fri, Aug 6, 2010 at 10:30 AM, Martinez, Marcelo A <marc...@cpchem.com<mailto:marc...@cpchem.com>> wrote: Thanks Mahendra, but I'm trying to run this query on tickets already in the system. i.e. All incidents from july 2010. I was afraid this wasn't possible. Marcelo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Mahendra Mahalkar Sent: Thursday, August 05, 2010 10:58 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: query on priority change ** Marcelo, The change in priority can be recorded/set in a temp field by using the filter having the run if as "TR.Priority != DB.Priority". If this change happen the temp field will set to a particular value. Then extract the report based on the qualification "temp field = value". Hope this helps ! Mahendra It's Mahendra !!! Error! Filename not specified. On Fri, Aug 6, 2010 at 1:22 AM, Martinez, Marcelo A <marc...@cpchem.com<mailto:marc...@cpchem.com>> wrote: May be an easy question.. I'm trying to run a search, in order to create a report, on incidents in which the priority changed. So if a user changed an incident from medium to low, or medium to high, etc.. it would show on the query. Any ideas how this can be accomplished? ARS7.1 ITSM7.0.03 TIA, Marcelo _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org/> attend wwrug10 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com<http://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"