Trying to find the table that has Workflow item scripts

[shembop]

We have items in our workflow scripts that I want to try and find and correct.What we have tried to do is find in what table the Advance field is housed for workflow items. This would allow me to find every item where we referenced the old field in a script.

[Chuck Tomasi]

Taking what Chris said with your original requirement... to find all usage of a variable in a workflow script... I came up with this simple query on sys_variable_value.

It appears to show all the uses of scripts in workflow activities. With additional filters you could look for your variable that way.