Skip to main content
Nintex Community Menu Bar

Retrieving List of Published Workflows

  • Feb 15, 2022 10:19 AM UTC
  • Feb 17, 2023 2:49 PM UTC
  • 0 replies
  • 176 views
  • Translate All

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