Query to pull error details of failed terminations from transaction console

Summary:

Query to pull error details of failed terminations from transaction console

Content (required):

We need a query to pull error details of failed terminations from transaction console. We have transaction which are errored out and later terminated which changes the status to complete. But if you check the transaction history of these aborted transaction you can see the error. Can you please let us know how to retrieve the error available in transaction history as shown in the snippet below.

I have checked the forum and I can't find any solution for retrieving the error in SQL.

Below is a snippet of the error that we wish to fetch from the back end transaction console tables: