Report displaying Flows and Db procedure

Unknown

Report displaying Flows and Db procedure

Unknown

Hi
I was trying to build a report that would display all the flows, their sub flows and all the dependent database stored procedures. I know the entity_header_data table gives us all the info but I would like to have data about these categories. Can you please suggest a way so that I can achieve this and as well use the suggested way to get data about other items too if required?
Thanks

Unknown

Hello Jibbin
Please find the SQL query attached that will give us the list of Flows created by users along with the list of Sub Flows and Database Stored Procedures contained in each of them. In this query, I have used module_resource_dependency and entity_header_data tables for fetching the required data. We can change the criteria in the query based on the item we would like to fetch.
Thanks