There are some really good products on the market that will do exactly what you are trying to achieve. Idera's compliance manager is one such product (there are others out there as well). This one is very easy to setup and configure and comes with a stack of Reporting Services reports as well.