We are required to start auditing our SQL Servers for various data points.  We did not want to write a custom tool if at all possible, so we started looking for third-party products.  We found Idera's SQL admin toolset.  It doesn't collect all of the information that we want to audit, but it's a great start.

Excerpt from their site about the tool:

Are you a DBA or developer tired of spending countless hours on routine administrative and troubleshooting tasks, like figuring out why a user can't connect, or moving databases, or producing reports for your boss to show that the backups really did run, or finding rogue SQL Servers, or checking configurations or…. yeah, we know, the list is endless.

If the answer is yes then, you need our SQL admin toolset. Packed with 24 powerful tools that will make troubleshooting, administration and reporting such a breeze you'll be wondering what to do with all the spare time you have on your hands - really! Download now and see.

I do not work for Idera.  I am not getting paid to write this nor was I asked to write this.  I found this tool to be so useful that I wanted to bring it to other's attention, especially since it's free to use right now.