Demo Virtual Machine
Check for unused procedures
Checks for any procedures in the RED metadata that are not used by any object.
How does it work?
This test case builds a list of all procedure keys used by any object within the RED respository by selecting the respective foreign-keys from the object-definitions.
It then joins this list to a list of keys of all procedures present in the [ws_pro_header] table. If there is one left in the [ws_pro_header] table, that cannot be joined to the first list, it is an unused procedure.
No configuration needed