We are re-doing some backend logic for a save action we created and I need to find all forms that use this one save action. How can I easily do that? I didn't see a way in Admin interface and I don't see how to query from SQL database.
Locate the Save Action in the content tree (e.g., for WFFM they live here
/sitecore/System/Modules/Web Forms for Marketers/Settings/Actions/Save Actions or
/sitecore/System/Settings/Forms/Submit Actions for the new Sitecore Forms), select the item, select
Navigate in the ribbon, and select
Links to get a full list of items that reference that Save Action.
Edit: If you find no references, it's a good idea to rebuild the links database. Here is a blog post outlining how to do that
If you want to customize the output through powershell since you mentioned wanting to see the paths you can use this blog post to get the relevant API