This could go many different directions/suggestions. Do you have a more defined end goal? For example, I want to automate a report that shows the transactions with this certain DB (NON-SSRS reporting). This should be something that runs daily and sent in an email to a distribution list. I also want to pretty up the formatting in the email; not just attach a CSV.
The reason I ask for more information is the solution could be as simple as you using an SQL statement with an invoke-SQL cmdlet output to a CSV; running daily per a scheduled task. Could also become complex; like uploading to be used in PowerBI etc..
I have some Powershell script that gathering all perfmon information during the test and all logs after it.
All what i do is starting it and putting my estimation for load test execution duration.
For example – 12 hours of overnight test.
Now i want to add more detailed information about the DB state during the test. Some CSV or HTMLs that could be useful...