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.
Find all Workflows in farm by last run date
+1
+23- Nintex Partner
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
+1Thanks for the script. Do we know if this script collects all workflows, list and site, associated with a particular database?
+23- Nintex Partner
Hi,
The script I have provided is per database.
The script provided by mlauer will show every workflow in the environemnt from all databases.
The script I have provided is per database.
The script provided by mlauer will show every workflow in the environemnt from all databases.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.