cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
marcdiller
Nintex Newbie

Find all Workflows in farm by last run date

Need to know which workflows are active in our farm(s), run in the last xx days. Ideally, a report listing each workflow, the collection and site it lives in, the workflow name, and last date run. I see lots of powershell to list workflows but do not see any to get last date run. 

Labels: (1)
0 Kudos
Reply
2 Replies
SimonMuntz
Nintex Newbie

Re: Find all Workflows in farm by last run date

Hi,

You could run a query on your content databases to get this information.

Select WorkflowName,MAX ([StartTime]) AS 'Last Started', SiteID, ListID, WebID
From dbo.WorkflowInstance
Group By WorkflowName, SiteID, ListID, WebID
0 Kudos
Reply
mlauer
Nintex Newbie

Re: Find all Workflows in farm by last run date

0 Kudos
Reply