How to query for "Processes with Errors"

Question

Hi everyone, 
 
 We have a requirement where we need to clean up old process instances from our Production environment as we have around 20,000 instances with errors in them that are taking up disk space. Instead of having our help desk team delete 25 instances at a time from the "Monitoring" View, I thought that we could create a process report that would contain all process instances with errors and have an automated process that queries that report and deletes those instances. However, I can't seem to find a filter criteria for "Processes with Errors". I know there are "Active", "Paused by Exception" etc. I also know that there is a report called "Processes with Problems" but that only filters by "Paused by Exception". How can I query for all the instances that have an error in them? Has anyone encountered this blocker? And if so, how did you get around it? 
 
 Thank you, 
 Rajiv Nelvoy

Chris · Answer

This can be tricky since AFAIK we cannot pull process instances into a report automatically when they are active (not paused), with any nodes that have encountered an error (such as a DB truncation error, or null function error). Paused by Exception is reportable, but otherwise we will do this per application when performing a bulk cleanup. Some things can be helpful such as creating reports for any active process instances that have 0 active tasks (only applicable for processes that always should have a task active). 
 Due to this, we make it a priority to review and resolve server alerts as they are thrown. In most cases, the processes can be adjusted to prevent future errors.