Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.
Welcome to Nintex Connect Sign in | Join | Help
in Search

Enable reviewer / manager to see status of workflow without opening 8t

Last post 10-03-2012, 1:30 PM by David Tobey. 1 replies.
Sort Posts: Previous Next
  •  06-21-2012, 4:42 PM 23579

    Enable reviewer / manager to see status of workflow without opening 8t

    Managers /reviewers would like to quickly get a status of a number of workflows without having to  open up each of them.  Is this possible with Nintex?

    Thanks

  •  10-03-2012, 1:30 PM 25422 in reply to 23579

    Re: Enable reviewer / manager to see status of workflow without opening 8t

    Depending on the edition of Nintex Workflow you're using, absolutely.

    If you're using Nintex Workflow Enterprise edition, there's a feature that allows you to see all in-progress workflows on your site.
     
    If you're using Standard, however, things get a little more tricky. You can try running the following SQL script:
     
    select I.WorkflowName, I.SiteID, I.WebID, I.ListID, I.ItemID, I.WorkflowInitiator, COUNT(P.WorkflowProgressID) as ActionCount 
    from WorkflowInstance I inner join WorkflowProgress P
    on I.InstanceID = P.InstanceID
    where I.State=2
    group by I.WorkflowName, I.SiteID, I.WebID, I.ListID, I.ItemID, I.WorkflowInitiator
    order by COUNT(P.WorkflowProgressID) desc
     
    However, both of these pale in comparison to what Nintex Analytics can offer you in terms of workflow metric insights. I would strongly suggest investigating Analytics if you're looking for real analytical insight into your environment.
     
    -- DT 
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems