Skip to main content
Nintex Community Menu Bar

Retrieving List of Published Workflows

  • February 15, 2022
  • 0 replies
  • 159 views

Forum|alt.badge.img+8

Topic

How to retrieve a list of published workflows and their corresponding list names.

 

Instructions

Run the following SQL query, replacing <Nintex database> and <SharePoint database> with the appropriate database names:
SELECT tp_Title as "List Name",ListId,SiteId,WebapplicationID,workflowname,WorkflowType,PublishTime,Author,VersionFROM <Nintex database>.dbo.PublishedWorkflows PWinner join <SharePoint database>.dbo.AllListsal on PW.ListID = al.tp_ID