BI query to find the count of Failed, aborted and recovered transactions

We are working on the list of Failed, Aborted and recovered Core HR transactions.
We were able to get the failed and aborted transactions list with the available status in hrc_txn_data table and hrc_txn_console_entry table.
However, we want to understand and get a list of recovered transactions, there is no way we could check the backend status of once the failed transactions, when it is recovered and gets completed, this still comes under completed, but at first place this was actually errored/failed.

We want to have a list of all core HR transactions that has been,