You might have to monitor multiple server and multiple instances if this is true then

1.Create a centralize monitor server (SQL server with single instance)

2.Create a table and store the SQL server inventory detail as explained below

SQLInventory

1.ServerID

2.ServerName

3.InstanceID

4.InstanceName

5.SQLVer

6.Enable_monitoring

SQLInvDetail

1. InstanceID

2. DatbaseID

3 DatabaseName

4. Enable_monitoring

Create another table that will store the information about the server and instance resource

usage

InstResource

1.ServerID

2.InstanceID

3.Fromtime

4.Totime

5.CPUusage

6.MemUsgae

DbRessource

1.InstnaceID

2.DBID

3. File1

4. GrowthMB

3. Now Create a SQL job that will connect to each server and collect the information and stored them in the InstanceRessource and DBressource table

Note; You can enable and disable monitoring for a particular Instance and User by setting using Enable_monitoring

Schedule the job to run as you needed

Now we can use the SSRS to design your report.

Hopes this gives you some idea. Let me know if this works

Cheers,

Gorachand Mohapatra