Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Finding a Workflow by InstanceID from ULS Logs

    Status: Validated

    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
    • Was this article helpful?