• First, do this for one server. Make a job that runs xp_fixeddrives and inserts the results (and the date) into a table on the instance. Write a cleanup task/job that deletes data that's, say, a year old, from the table.

    Once you have this, then it's a question of making a remote call from your centralized server and retrieving the information from each server and inserting it into the central instance. I would actually look at Powershell for this, looping through a list of servers, reading the table, inserting into your current server.

    For a report, it's a simple query. Select server name, date, drive, diskspace, order by diskspace ascending.