You are viewing limited content. For full access, please sign in.

Question

Question

Feature Request: Search for Workflows Not Being Used

asked on June 29, 2022

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.

2 0

Replies

replied on June 29, 2022

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.

4 0
replied on June 29, 2022

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.

1 0
replied on June 30, 2022

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.

0 0
replied on June 30, 2022

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.

1 0
replied on June 30, 2022

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.

0 0
replied on June 30, 2022

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.

0 0
replied on July 1, 2022 Show version history

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.

0 0
replied on July 1, 2022
select * from workflow where workflow_id not in (select distinct workflow_id from workflow_reporting_log)

 

2 0
replied on July 1, 2022

Blake, I've filed this as Workflow feature request #385227, "Include workflows that have never run in Workflow Statistics Reports".

0 0
replied on July 1, 2022

Much appreciated Samuel. Thank you!

1 0
replied on February 27

It should be noted that this information is accessible in the Laserfiche Cloud Migration Readiness Assessment tool.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.