TOPIC
In most instances when a workflow starts its location in SharePoint is not listed in the ULS logs especially if the workflow is started on the Microsoft SharePoint Foundation Workflow Timer Service. Following these steps a workflow in SharePoint can be found based on its Workflow InstanceID in the ULS logs.INSTRUCTIONS
- In the message column of the ULS logs look for a line similar to: Processing 1 events for workflow instance: 4b0d579c-2036-4080-aeb9-9fb0623f436e
- Using the instance ID look in the message column for text similar to: Opening connection : Data Source=prodcontentdb;Initial Catalog=01_NintexDB_03;Integrated Security=True (Build:3070)
- Note the Nintex database name as this will be used in the below SQL query to find the workflow SiteID, WebID and ListID.
/*Update to the name of your Nintex Content Database obtained from the ULS logs. */
SELECT * FROM dbo.WorkflowInstance
WHERE WorkflowInstanceID = '408c7d6a-b919-4c84-b7b8-e410e6b3d2d3'
SELECT * FROM dbo.WorkflowInstance
WHERE WorkflowInstanceID = '408c7d6a-b919-4c84-b7b8-e410e6b3d2d3'
/*Change Workflow Instance ID to track additional workflows*/
Run this set of Power-Shell commands to find the URL of the workflow: