Hi Folks! Danny's right, I allways use the following as well to determine just how much fixing is required:
select distinct tfServer from field_table select distinct sampleServer from field_table select distinct serverName from actlink_open select distinct server from char_menu_query select distinct sampleserver from char_menu_query select distinct server from char_menu_sql and for more detail: select * from field_table where not tfServer = '@' select * from field_table where not sampleServer = '@' select * from actlink_open where not assignShort like '%...@%' or not assignLong like '%...@%' select * from char_menu_query where not server = '@' select * from char_menu_query where not sampleServer = '@' select * from char_menu_sql where not server = '@' Normally, it's best to formulate the updates according to the output of the above after backing up the DB. Best Regards, Theo -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Danny Kellett Sent: 24 May 2010 08:34 PM To: [email protected] Subject: Re: Tool for finding out the workflow with hardcoded values. (UNCLASSIFIED) I think there are a few more places like the one for table fields etc -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Luttmann, Michael W CTR USA Sent: 24 May 2010 19:17 To: [email protected] Subject: Re: Tool for finding out the workflow with hardcoded values. (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: FOUO I have SQL routines for this. Here is an example: DECLARE @string varchar(30) SET @string = '%HardcodedText%' SELECT name "Active Link", queryShort FROM actlink WHERE queryShort like @string SELECT name "Filter", queryShort FROM filter WHERE queryShort like @string SELECT name "Escalation", queryShort FROM escalation WHERE queryShort like @string I used variables so that it would be easy to run while looking for different values each time you use it. Replace 'HardcodedText' with the words you are looking for. Mike L. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Danny Kellett Sent: Monday, May 24, 2010 11:58 AM To: [email protected] Subject: Re: Tool for finding out the workflow with hardcoded values. :) But then you have the def for when you forget tomorrow after all that beer ;) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jarl Grøneng Sent: 24 May 2010 18:21 To: [email protected] Subject: Re: Tool for finding out the workflow with hardcoded values. 2010/5/24 Danny Kellett <[email protected]>: > > And these tools are great and have their place BUT for the posters > issue, I > think a def file opened in a text ed and a search will do the trick > plus it > doesn't fire a load of API calls to the AR Server. But exporting the def does fire a load of api calls :-) -- Jarl ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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" Classification: UNCLASSIFIED Caveats: FOUO ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
