I inherited a 2020.4 Alteryx server. My department has to migrate all of the workflows to a new 2024 server. Most users are taking care of their own workflows; however, there are many workflows owned by people that are no longer with the company that need to be migrated and I will rebuilding those on the new server. There is a set of 100+ workflows that the department depends on for reporting that are owned by somebody no longer with the company. Many other workflows are dependent upon tables created by those workflows. The business will be letting me know which tables they need to READ FROM and I will need to rebuild the workflows that write to those tables in a more optimized fashion. However, I don't want to have download and then parse 100+ workflows to find which workflow writes to Table "A". Most of the tools and workflows I've found so far that would work for this are only compatible with 2021.4+, so I can't use those.
Does anyone have a python script or SQL script I can use against the Gallery MongoDB that searches workflows for a key-word and returns the workflow name where that keyword is found?
