I am in the process of reviewing the various workflows that are on our workflow server and finding which ones have no instance history so they can be reviewed and figure out if it is safe to delete them. I am currently having to select each workflow 1 by 1. It would be great if there was a way to search for all workflows that have no history.
Question
Question
Replies
Have you tried running a statistics report instead? It will give you a breakdown of all history by workflow name and version. It has more historical data on instances because it pulls from the reporting data (which is retained for 365 days by default) rather than the instance search data (which is retained for 30 days after instance completion by default).
As a bonus, it's also gentler on the database since it's not trying to retrieve individual instance details.
I do like that report, but it doesn't look like it includes the workflows that haven't been run. For this specific use case I would like to see those included so I don't have to compare the workflows that are published with the ones that don't show up in the statistics report.
This is really slick. I used this today but got stuck trying to do the same for Forms
I went to Monitor and got a list of all processes run in the last year, but the only way I know to remove duplicates is with Google Sheets, yet I can't seem to get the data out into a CSV or Excel document.
The statistics report? There's an export option if you right-click on it in the Workflow Designer. It will dump all data to CSV.
This is in Forms, is there a statistics report option in Forms? I was just using the Monitor page.
With Workflow I have everything I need, it already shows unique workflows and instance counts.
Blake, if you open the statistics report data and your list of published workflows side-by-side, surely it cannot take more than a few minutes to diff them and make your list of never-run workflows.
The request to include workflows that haven't run in the statistics report is reasonable though. I'm happy to file it with a low priority tag.
Between 2 workflow servers there are a little over 200 workflows. We currently have 5 workflow servers with plans to add a 6th in the near future. Doing a side by side comparison is doable, but not the most efficient use of our time. Thank you for putting in the feature request.
select * from workflow where workflow_id not in (select distinct workflow_id from workflow_reporting_log)
Blake, I've filed this as Workflow feature request #385227, "Include workflows that have never run in Workflow Statistics Reports".
Much appreciated Samuel. Thank you!
It should be noted that this information is accessible in the Laserfiche Cloud Migration Readiness Assessment tool.