Hi ..

There could be many ways to generate backup reports and send that to distributor ...

1. Create a centralize Database suppose here it is DBA_Activitiy

2. Create one .txt file which can contain all the mail id where you want to send reports, you can keep other information in this file.. Suppose here it is ReportCofig.txt

3. Create a table which will contain all the server/instance details, Suppose here it is ServerDtl_tbl

4. Create one SSIS package which will read the ServerDtl_tbls .. loop thru to all the SQL Instances .. Run the query to gather backup information from MSDB database and store the data into the Centralize Database (DBA_Activity)... Suppose one table BackupDtl_tbl

5. Create one VBScript to generate the report and send mail to distribution... This VB script will read the .txt file ReportConfig.txt

6. Create one schedule SQL Agent job which will execute the VB script for generating report and send report.

7. In that SQL job you can add steps to data purge from the BackupDtl_Tble, Delete old backup reports etc.