Retrieving List of Published Workflows

  • 15 February 2022
  • 0 replies
  • 101 views

Userlevel 3
Badge +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

 


0 replies

Be the first to reply!

Reply