Where are the details of Flow Actions stored?

[gjz]

Does anyone know what table holds the details of actions in a flow?  There are times I am looking for an example of something that was done in an action and I'm looking for a way to search instead of opening each action and seeing what is inside.  I used to be able to do this with workflow.

For example, I remember writing an action with a script that does something complex, but I don't remember which action it is in.  With workflow, I would open the table that held the workflow script and would search on the script field to find what I'm looking for.  How can I do that with flow actions?  What table holds that information?  We have over 1000 actions, opening each one is not really an option.

[Bhuvan]

@gjz 

Check if you are looking for below information

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0761115

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[kaushal_snow]

Hi @gjz ,

Flow Designer actions are primarily stored in the sys_hub_action_type_definition table, which contains definitions for reusable action types, including their scripts and configurations. When these actions are used within flows, instances of them are recorded in the sys_hub_action_instance table, capturing runtime details such as input/output variables, execution status, and related flow context.

To locate a specific action, you can query the sys_hub_action_type_definition table using keywords from the action's script or name. For runtime details, the sys_hub_action_instance table provides information on where and how each action was executed within a flow. Additionally, the sys_variable_value table stores input and output variables associated with these actions, which can be useful for tracing data flow and debugging....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[gjz]

I think I've misled everyone.  I'm not looking for the action, I'm looking for specific code within a script step in the action.  I want to be able to search the code in a script step - and I can't find where the code is stored.  I don't need the action name, I don't need the input or output variables, I need the code.

For example, let's say I've written 10 custom actions.  Each custom action has a script step and each script step does something different.  Let's assume one of them calls a script include.  If I can't remember how to call a script include from an action step (I do know how to call a script include from a flow action script step, that's not what I'm looking for), then I want to be able to search every script step in an action to find the script. include name, or any other code that may be in the script include.

I just want to do a simple wildcard search on the script code.

[Bhuvan]

@gjz 

Did you get a chance to look at the knowledge article I shared ?

Refer below link from your instance to locate all tables related to Flow Designer

https://<instance>.service-now.com/sys_db_object_list.do?sysparm_query=sys_update_nameISNOTEMPTY%5En...

I believe the table you are looking for is sys_hub_input_scripts. You can validate it or look for related table from the list

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[gjz]

Hi Bhuvan,

Yes, I did look at the KB but it didn't have what I'm looking for.  I did see sys_hub_input_scripts, but it also doesn't have what I'm looking for.  For example, in one of the script steps in one of the actions I have the line "var locationStr = inputs.location".  When I do a wildcard search on locationStr, it doesn't find it.

The closest I've come is sys_hub_step_instance - which if you open one of the records, you can find the script value, but field's dictionary says it's a variable.  If I could figure out where the variables are stored, I can probably find what I'm looking for.