Topic
In troubleshooting issues related to missing scheduled workflows or to map which scheduled workflows are linked to which Nintex Content DB, run the following SQL query
Instructions
/****** Script for SelectTopNRows command from SSMS ******/
SELECT
db.DatabaseID 'NW ContentDB ID',
db.DatabaseName 'NW ContentDB Name',
ServerName,
ws.SiteId,
ws.WebId,
ws.WorkflowId,
pw.WorkflowName,
NextRunTime,
IsBroken
FROM [NW2013DB].[dbo].[WorkflowSchedule] WS
left join Storage ST on ws.SiteId = ST.SiteID
inner join Databases db on st.DatabaseID = db.DatabaseID
inner join PublishedWorkflows pw on pw.WorkflowId = ws.WorkflowId
group by ws.WorkflowId,
db.DatabaseID,
db.DatabaseName,
ServerName,
ws.SiteId,
ws.WebId,
pw.WorkflowName,
NextRunTime,
IsBroken
SELECT
db.DatabaseID 'NW ContentDB ID',
db.DatabaseName 'NW ContentDB Name',
ServerName,
ws.SiteId,
ws.WebId,
ws.WorkflowId,
pw.WorkflowName,
NextRunTime,
IsBroken
FROM [NW2013DB].[dbo].[WorkflowSchedule] WS
left join Storage ST on ws.SiteId = ST.SiteID
inner join Databases db on st.DatabaseID = db.DatabaseID
inner join PublishedWorkflows pw on pw.WorkflowId = ws.WorkflowId
group by ws.WorkflowId,
db.DatabaseID,
db.DatabaseName,
ServerName,
ws.SiteId,
ws.WebId,
pw.WorkflowName,
NextRunTime,
IsBroken
Additional Information
Some of the results may have null values, which indicate the relationship between the scheduled workflow and where the workflow resides in the Nintex Content DB is no longer valid.