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.
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