I am migrating a sharepoint farm and need to update all SPD workflows in the migrated site collection. I need to get a list of all SPD workflows that exist in the site collection so I can update URLs, email addresses etc.
I know I can open each site in SPD and check for workflows from there - however, there are over a 100 sites and subsites and I'm sure there is a better way to list all workflows (SQL query, Powershell script).
Any help would be appreciated, Greg
Update: Ok, so a quick and dirty way of listing all workflows is to run the following SQL query on the content DB
SELECT dirname, leafname FROM allDocs WHERE LeafName LIKE '%.xoml'
If anyone has a better way (Powershell anyone?) let me know.