Topic
How to find the location of each User Defined Action (UDA) in the farm.
Instructions
- In Nintex Configuration Database open dbo.UserDefinedActions table and find the desired User Defined Action.
- Note the UdaId.
- Open dbo.UdaUsage table and filter where UdaId is equal to the one noted above, note the PublishedWorkflowID. Use the below query
- Select distinct PublishedWorkflowId from dbo.udausage
- The resulting list of workflows contains the desired User Defined Action.
- Query dbo.PublishedWorkflows and filter by 'Id' with the PublishedWorkflowID you have obtained from step 3. Now you should have all the required data in the PublishedWorkflows table to find the workflows that use that UDA.
Additional Information
Note: All the tables are in the Nintex Configuration Database
