Table stored Run Script activities in workflow

[miro2]

Hi

In which table stored Run Script activities where I can find code? I can't find mentioned table. 

[Mark Roethof]

Hi there,

I believe you are after the sys_variable_value table.

This is also described in one of my articles:
Finding references (sys_ids) in Workflows

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Michael Ritchie]

Michael, let me clear this up for you!  Workflow activities use variables so the values you see in the scripts and other fields are stored in the sys_variable_value table.  There is a clue to know this by following your instructions above to navigate to the wf_activity table and pulling up a record but if you right-click and show XML you will see the additional record:

So @miro you can navigate directly to sys_variable_value and search where value contains X to find what you are looking for.  Its worth mentioning that sys_variable_value also stores values for Flows and ATF as well!

Hope this is helpful.

[Mark Roethof · Accepted solution]

Hi there,

I believe you are after the sys_variable_value table.

This is also described in one of my articles:
Finding references (sys_ids) in Workflows

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Mark Roethof]

For example:

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Michael Jones -]

Thanks Mark R and Michael R! 

I've looked for this in the past (obviously) but hadn't figured it out down to that level. 

Simple enough then: sys_variable_value.LIST and Value * with a code snippet should show where code exists, if it's within a workflow task. Nice!

Thank you for the clarification!