Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to check workflow runscript activity's where assigned_to = some sys_id

KaMmILa__
Tera Expert

We have a user who sys_id is hardcoded in multiple workflows run script , how to find which workflow have that sys_id ?

1 ACCEPTED SOLUTION

Prasad Dhumal
Mega Sage

Hello Kammila,

Please follow Michael Domke's solution:

Yes, you can do this search.
1) In the Navigator filter box, type sys_variable_value.list <-- This takes you to the table to search
2) Click on the Filter wizard icon to create a custom filter
--- Table (document) is wf_activity AND
--- Variable.Column Name contains script' OR
------ Variable.Type.Name contains 'script' AND
--- Value contains [whatever you are searching for]

Although, I could not find Variable.Type.Name in the filter wizard. Variable.Type didn't show to have any related fields.

 

Searching the script field(s) of workflow activities - Developer Community - Question - ServiceNow C...

View solution in original post

3 REPLIES 3

Prasad Dhumal
Mega Sage

Hello Kammila,

Please follow Michael Domke's solution:

Yes, you can do this search.
1) In the Navigator filter box, type sys_variable_value.list <-- This takes you to the table to search
2) Click on the Filter wizard icon to create a custom filter
--- Table (document) is wf_activity AND
--- Variable.Column Name contains script' OR
------ Variable.Type.Name contains 'script' AND
--- Value contains [whatever you are searching for]

Although, I could not find Variable.Type.Name in the filter wizard. Variable.Type didn't show to have any related fields.

 

Searching the script field(s) of workflow activities - Developer Community - Question - ServiceNow C...

Thanks for the reply , but how to see which work flow it is attached to ?

Apply below filter in sys_variable_value table

find_real_file.png

 

This filter will give you records which contains sys_id which you put in 'value'

Open that record, and refer below screenshot which will give you workflow:

find_real_file.png