Skip to main content
Nintex Community Menu Bar

Find out which workflows have Enterprise Actions

  • March 9, 2020
  • 1 reply
  • 4 views
sumitdeJedi
Nintex Employee
Forum|alt.badge.img+9

If you need to audit which of your workflows have run and contained enterprise workflow actions, then you can run this script against your Nintex Content DB:

 

Select distinct WorkflowName, CurrentActivityTitle, ListID, SiteID, WebID 
from WorkflowInstance wi

inner join WorkflowProgress wp on wi .InstanceID = wp . InstanceID

inner join <Nintex Workflow ConfigDB>.dbo.Activities Ac on CurrentActivityTitle = ActivityName where RequiredFeatureSet = 100

Replace the <Nintex Workflow ConfigDB> with the name of your Nintex Config DB.

 

This script will need to be run against all of your Nintex Contents, and will only return those workflows that have been run at least 1.

    1 reply

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • March 9, 2020

    If you want to look for specific actions you can use:

    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' Or P.CurrentActivityTitle Like 'Copy to SharePoint'

    Replace the action names as required.

    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement