Looking for all Execution flow -> "Server command" steps in procedures with the Impact Analysis

Manuel Granada

Good morning,

Recently we have been trying to solve an issue related to the server commands launched with some database procedures.

We needed to find out all the procedures that have a step for launching an external process, like a python script for example. And now that the Metadata feature is not available anymore, the Impact Analysis feature is the only way to study all the database related information.

But in this case, this Impact Analysis feature is not able to solve this issue, as there is no filter for steps in a procedure.

That is the reason we have decided to open this idea, in case it can be considered for future improvements.

Thank you.

Sergi Fernández

Hello @Manuel Granada ,

Totally agree, it would be really useful to be able to inspect more details from the Impact Analysis, as some procedure steps don't appear there.

As a workaround, in the "ProcedureExecution" logs, you'll find the different server commands that have been executed, with useful information like the procedure that ran that step, or the file that has been executed. You won't find information about steps that haven't been executed there, but it can still help with the task.

Best regards,