Skip to main content
Nintex Community Menu Bar

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 sNumber of Instances]FROM dbo.workflowInstanceWHERE State = '2'GROUP BY WorkflowNameORDER BY COUNT(WorkflowInstanceID) DESC

 
Be the first to reply!

Reply