Just as another option if you work at a shop that does not allow Ole Automation to be turned on (some consider it a security risk), you can do the same thing with Powershell without having automation turned on (for that matter you don't need to have SQL on the server at all....if you ever need to keep track of this on non-SQL boxes).

There are lots of really good articles posted by Chad Miller, and with them you can put together all kinds of great information using powershell.

http://www.sqlservercentral.com/Authors/Articles/Chad_Miller/421/