Thanks & Regards
The logs you shared from sis-console.0 are from 2020, not 2022 (it shows connectivity errors with SQL server). If you scroll down to the bottom of the log file, you will see the most recent events. My guess is you will see the same error messages.
If you look at the results from the SQL query in SQL SMSS you have over 5.6 million records and it took 29 minutes to run the query. This is way too much data to extract through the Java console, it's going to continue to timeout. You can try and save the results in SMSS to a CSV.
What is it that you are trying to do with the data? Can you narrow down what exactly you are looking for?
We (northstar.io) do sell a product called SOLVE for DCS which is a reporting tool. It would allow you to slice the data up so you could drill down into it. I think though you are generating too many events and need to tune the policies. For detection policies use the "ignore strings" and only enable the rules you need. For prevention, the policies should be tuned to allow the systems to function and lock them down so that you are only seeing actionable events.