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
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
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