Skip to main content
Search Again

We think these articles could help you:

    See More

    ALERT: This site will be decommissioned at the end of December 2018. All existing and new Nintex knowledge content will be available within the new Knowledge Base area of the Nintex Community site. 

    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?