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.

[GlideFather]

Hi @gjz,

check these tables:

• [sys_hub_flow]
• [sys_hub_action_type_definition]

It might be helpful, let me know if that helped

[gjz]

Hi GlideFather - neither one has what I'm looking for, but I did find sys_hub_step_instance that has the script in it - but it's a variable.  That must be stored somewhere!

[GlideFather]

@gjz I'm not sure that I understand what you're looking for, but I can give you this "crossroad":

Navigate to the [sys_db_object] which is a table that stores all the tables:

https://your-instance.service-now.com/sys_db_object_list.do?sysparm_query=nameSTARTSWITHsys_hub_

And search for tables starting with "sys_hub_", there are 61 in my PDI, perhaps your number will vary. And you can play with the filters - extends any table etc... also, some of the tables might be overlapping. 

Good luck searching!

[Ankur Bawiskar]

@gjz 

tables are already shared by @gjz 

If my response helped please mark it correct and close the thread so that it benefits future readers.