Zahid Ahamed
asked on
SQL Server Inventory using SSIS/SSRS for reporting.
Hi Expert,
I want to inventory all of my SQL Server Instances along with Server Name, DB_Name, DB_Owner, Create_Date, Version, Edition, Recovery_model as much i can retrieve.
Please Help!
I want to inventory all of my SQL Server Instances along with Server Name, DB_Name, DB_Owner, Create_Date, Version, Edition, Recovery_model as much i can retrieve.
Please Help!
Most if not all of this information should be available in the system catalog views, particularly sys.databases, and you should be able to write dataset queries against them to obtain the information for a given server. Coalescing that data from multiple instances could prove a little more challenging.
I'm thinking that you could write the the report as two RDLs, an outer report and an inner subreport, where the subreport displays data for one server instance, and the outer report supplies the instance connection strings. The question then becomes whether the server name for the subreport's data source can be parameterized. It seems like it could work, but my experience with subreports is that not everything that is supposed to work actually does. In particular, when do subreport datasets load? I don't remember off the top of my head.
I'm thinking that you could write the the report as two RDLs, an outer report and an inner subreport, where the subreport displays data for one server instance, and the outer report supplies the instance connection strings. The question then becomes whether the server name for the subreport's data source can be parameterized. It seems like it could work, but my experience with subreports is that not everything that is supposed to work actually does. In particular, when do subreport datasets load? I don't remember off the top of my head.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You!
ASKER
Do i have to establish management server? or any other option?