What is the best way to clean up and delete useless / redundant History entries?

Hi community,

I assume many of you use the item history for Parts, CAD or other ItemTypes. Dependent on how you configured the history, the history entries itself are more or less useful.

I noticed that we get a lot of useless history entries, when users do mainly relationship edits. In this case we often have plain "update" entries without any comment. Some of these empty "update" entries are caused by Methods in the background. See also:  link 

The history table can be one of the biggest in Innovator, so I wonder if we can do some cleanup to optimize the data quality?
In our case I expect 20%-25% of the history entries to be redundant. 

I definitely don´t want to remove all "Update" related entries. But I only want to store the "last" entry of a major change operation.
Just the ones that are around less than 30 seconds apart, were created by the same person and have no comment.

Example:

Is there any other answer than "SQL" (or AI ) to analyse which entries can be deleted?

Is there anything else we need to consider? Thanks for any suggestions or second thoughts!

Angela