• There are two parts to your process.

    1) Information gathering

    2) Report generation.

    For the information gathering you could implement this in

    a) Scheduled T-SQL script if you're able to use linked servers.

    b) SSIS package which uses a servers table(where your server name and login details are stored) to generate the connection string dynamically then gather the required index info to be stored in a central database.

    c) Scheduled PowerShell script.

    Once you have all your index stats from all instances and all databases, it should be straight forward to generate the SSRS report.

    See which option you can use to gather he info and if you need help with implementing an SSIS solution then let me know and I will help you get this to work as I have recently done a similar exercise.

    Good luck!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn