Maksymilian, thank you for your help and clarification :)
Maybe I wasn't very clear 😊 - I don't want to use "sql command" to call this query. I am using SSMS. I meant to find all the places in the system where the functions visible in Studio as "Integration -> SQL COMMAND" are used, and the rest where pure SQL is used.
Needs to list from all processes all SQL queries along with what connection/data source they relate to, process, workflow, attribute/path, etc. The whole system consists of many complex processes that may use data pulled directly from SQL databases. I am hoping that this approach will be more ac
Thank you Maksymilian for the hint. Do you think this idea is also good for retrieving the sql queries themselves from the data sources? Or is this rather unrealistic due to the possibility of nested "SQL COMMAND" action calls?
In Designer Studio it is possible to check the use of a single connection or data source in the context of all processes. Is it possible to get such a list for all connections and sources using an sql query?