Get list of UDAs

[nigade_shashank]

I have a requirement to get a list of User Defined Actions (UDA) across a web application. Is this feasible if yes can someone share the PowerShell script for the same.

Thanks

[nigade_shashank]

Please help!

[sumitdeJedi]

Hi @nigade_shashank 

Not sure if you still need this, but I thought I'd share this in case anyone else has the same question,

the following blog, has a powershell script which might meet your requirements:

https://www.sptrenches.com/2017/04/nintex-workflow-uda-usage-report.html

Alternativly, you can run the following SQL query on your Nintex Config DB, which will retrieve a similair set of information:

SELECT workflowname, pw.Version,WorkflowType,name as 'UDAName', uda.Id as 'UDAID in UDA tbl', UU.UdaId as 'UDAID in Usage tbl', pw.SiteId, pw.WebId, pw.ListId
  FROM [UdaUsage] UU

  left join Userdefinedactions UDA on uu.udaID = UDA.Id

  inner join PublishedWorkflows PW on uu.PublishedWorkflowId = PW.Id

Hope that helps,

Sumit

Alter