So.. we have times when one of our customers would like to see a comprehensive display of what is being done and when on their servers, without the “lingo” thrown in.  Specifically, we’d love to see something like:

Client

1. Hostname
   1. Subclient
      1. What is backed up (in some form.. VM, FileSystem - what folders )
      2. Where it’s backed up (from storage policy information)
      3. The schedule for when it’s backed up (from schedule policies)
      4. All backup jobs, including in the storage policy copies

#1.1.1 will likely be a repeated column header with 1.1.2,3,4 repeated for each subclient. 

Is there such a thing existing?  I’ve searched near and far but found nothing.  

Also.. is there a data dictionary that can help with finding information with the datasets?  Or even reporting straight from SQL Server?  Finding the information in Management Studio seems tough.  I’ve actually copied it to SQL Server Express just to play with it w/o blowing up my whole installation.

Thank you for any help!