cancel
Showing results for 
Search instead for 
Did you mean: 

Finding a Workflow by InstanceID from ULS Logs

TOPIC
How to locate a workflow in ULS logs using the InstanceID.
INSTRUCTIONS
  1. In the message column of the ULS logs, find a line similar to the following: Processing 1 events for workflow instance: 4b0d579c-2036-4080-aeb9-9fb0623f436e
  2. Using that instance ID, locate text similar to the following in the message column: Opening connection : Data Source=prodcontentdb;Initial Catalog=01_NintexDB_03;Integrated Security=True (Build:3070)
  3. Note the Nintex database and use this query in SQL to find the workflow SiteID, WebID and ListID:
    USE NW2010DB //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' //Change Workflow Instance ID to track additional workflows
  4. Run this set of Power-Shell commands to find the URL of the workflow:
    $siteid = 'GUID of the SiteID' $webid = 'GUID of the WebID' $listid = 'GUID of the ListID'  /* Used for list workflows */ Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $list = $(Get-SPSite -Identity $siteid).Allwebs[[System.Guid]$webid].Lists[[System.Guid]$listid] $list = $(Get-SPWeb http://URL).Lists[[System.Guid]listid] $list.url $list.title  /* Used for Site Workflows */ Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $site = $(Get-SPSite -Identity $siteid).Allwebs[[System.Guid]$webid] $site.url $site.title
ADDITIONAL INFORMATION
RELATED LINKS
Labels: (1)
Version history
Revision #:
1 of 1
Last update:
‎11-20-2018 09:55 AM
Updated by: