This requires a full version of SQL
It runs the query nightly (set up as an SQL job) using SSIS which saves the output to CSV
- The tech1query.sql script extracts the data
- Full SQL with SSIS required
- Use an SSIS package to run the query and this outputs the result data as a csv file at a location on disk that you define in the package
- Use an SQL server agent job to run this package at a regular interval (i.e. as an overnight job)
Note: For an understanding of the data extracted please read through the SQL query
Repeating these steps with any query of your choosing is a useful tool to extract any data you may like.