Flow Designer Flow's action storage table

[Rooma1]

Just as workflow variables are being stored in the sys_variable_value table, I would just like to ask where the actions - Ask for Approval value get stored in the servicenow?

I need to build a script which will validate if any group approval has been used in the flow designer before deactivating the group.

Thanks,

Rooma

[gurjot5]

Hi @Rooma1 thanks for elaborating , the table which stores these individual action activities of a flow is [sys_hub_action_instance] , this stores individual activities defined in a flow , below is what you are looking for 'Flows where Ask for Approval Action has been used'

Additionally you can append - /now/nav/ui/classic/params/target/sys_db_object_list.do%3Fsysparm_query%3Dsys_update_nameISNOTEMPTY%255EnameSTARTSWITHsys_hub_

This lists all tables flow designers uses

Please mark my answer as correct and helpful if it solved your question 

[OlaN]

Which is what I replied a couple of days ago, you could just have referenced to my answer... 😀

[Rooma1]

Hi @OlaN & @gurjot5 

I am trying to find specific flows and flow actions where there has been group approval definition for specific group. Which table should I query for the sys_id of the group or the name of the group to find them?

[sys_hub_action_instance] table doesn't have reference to the group definition tables.

Thanks,

Rooma

Thanks,

Rooma

[OlaN]

I don't think you can get that data without knowing exactly what you're after.

I you have chosen a static group, then you'd be able to find a reference to the SysID of the selected group, but if it's dynamically set (through data pills) you cannot extract the group ID.

See examples below;
In the first image, I've set the ask for approval to a specific group.

In the second image, I've set the ask for approval dynamic through data pill.

[OlaN]

Hi,

The actions themselves are stored along with all the other flow actions (i.e. not only the approval action) in the table:

[sys_hub_action_instance]