Skip to main content
Nintex Community Menu Bar
Knowledge Base

Nick SQL Query Test 10/24/2023

  • October 24, 2023
  • 0 replies
  • 3 views

Topic

There's an issue with a database.


Instructions 

Run this SQL query:

--Run against Nintex Content databases
SELECT TOP 10 WorkflowName, COUNT(WorkflowInstanceID)as [Number of Instances]
FROM dbo.workflowInstance
WHERE State = '2'
GROUP BY WorkflowName
ORDER BY COUNT(WorkflowInstanceID) DESC


Additional Information

SQL Query as a code snippet
 

--Run against Nintex Content databasesSELECT TOP 10 WorkflowName, COUNT(WorkflowInstanceID)as [Number of Instances]FROM dbo.workflowInstanceWHERE State = '2'GROUP BY WorkflowNameORDER BY COUNT(WorkflowInstanceID) DESC