Skip to main content
Nintex Community Menu Bar

Extracting workflow history from SQL

  • October 28, 2019
  • 3 replies
  • 20 views
Forum|alt.badge.img+1

Hello -

 

Is it possible to pull workflow history (e.g., event type, user ID, outcome, status etc) by querying the backend SQL database (NW2013DB)?   If so, which table contains this info?  

 

thanks

    3 replies

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • October 29, 2019
    Hi,

    The dbo.workflowProgress Table stores Nintex Workflow History.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Forum|alt.badge.img+1
    • rman
    • Author
    • October 29, 2019

    Thanks Simon.   I checked that table and it only gives me the columns in attached picture. .

    How can I retrieve the highlighted info from 2nd pic?

     

    5137iD33E5E8E0D021B1B.jpg5136iC086F447B2054934.jpg

     

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • October 30, 2019
    Hi,
    The highlighted screen shot is from SharePoints Workflow History page which would come from the SharePoint content database.
    Please see this blog for the difference.
    https://community.nintex.com/t5/Community-Blogs/Demystifying-Workflow-History-Part-1/ba-p/78139
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement