How to find which workflows contain a certain action
How to find which workflows contain a certain action.
Running the following script on your Nintex content database(s) can provide this information. The below example looks for the Call Web Service action.
Select Distinct I.WorkflowName, P.CurrentActivityTitle, I.ListID, I.SiteID, I.WebID From dbo.WorkflowProgress P inner Join dbo.WorkflowInstance I ON P.InstanceID = I.InstanceID Where P.CurrentActivityTitle Like 'Call Web Service'
The script queries the Nintex Workflow Data which means the workflow has had to be run and the dbo.workflowProgress table has not been purged for the workflow to be returned in the query.