How to export data from TPROCESSLOG table data management

Im trying to create a process with sql qurey on maintenances tables (Like TPROCESSLOG, TPARTITION and others) to export data to a file . This is to get process details history on pipeliens. Where do i need to run this sql qurey.

I have looked around on report definition but no luck and also built an integration looks like its not correct process.

Is that any other way to run this qurey and export process details or past certain days(1-2days something)?

Thanks