How to identify which TABLES a FLOW is created for?

[Suggy]

We have several FLOWS created in our instance for which targets different CMDB tables (windows, storage, firewalls tables etc).

Question - Is there a easy way a to identify which flow is targeting which table? (ie. Assume that for writing data into Windows server table, there would have been 3 flows created. So my requirement is to idenity WHICH flows targets Windows server table?)

I need this info for documenting, troubleshooting etc.

If it was a Business rule, I can directly open Business rule written on Windows server table and find it out, but not able to easily get this info when FLOWS are used.

[Amit Verma]

Hi @Suggy 

You can query the sys_flow_context table to get this information. On this table you can refer 'Source table' , 'Source Record' fields against your flows to get the CMDB tables.

Thanks and Regards

Amit Verma

[Suggy]

HI @Amit Verma Thanks for replying but that doesnt fulfil my requirement. I have updated my question with more details.

[Mark Roethof · Accepted solution]

Hi there,

Are you after Flows directly triggered by inserts/updates on a specific tables? Similar like business rule? Or are you after something else?

If it's just that... sys_variable_value is your answer 🙂

[Suggy]

Thanks Mark, below helped me to know all that I needed 🙂

sys_hub_action_instance

sys_variable_value