Curious about the decision to use linked servers for the purpose of extracting a bit of info perhaps once a day.

Since these are all servers under your control, would it not be easier and lighter on resources to add a command to the nightly maintenance plan on each server to collect the info into a table per server, then have one go at collecting it into the "Central Repository" from your reporting application by connecting to each server ?

I'm just a bit uneasy about linked servers, is all... would like to hear other opinions.

Congratulations on a well documented article.