December 15, 2011 at 4:41 pm
how I can create a report showing the filegroup information from all databases in an instance?
For example as shown in the following output:
Name_BD GroupNameSize_MB Used_MB Free_MB Tam_Max Pct_Usado
----------- --------- ---------- ---------- ---------- ---------- -----------
PRUEBAS1 PRIMARY4728.00 4727.13.88-.01 99.98
PRUEBAS2 PRIMARY62825.88 62320.31 505.5690000.00 99.20
PRUEBAS3 GROUPNAME170000.00 63406.44 6593.5670000.00 90.58
PRUEBAS4 PRIMARY319.38 319.25.13-.0199.96
December 15, 2011 at 5:00 pm
Well, you can gather all of the information and dump it into a table, and then query that table from SSRS.
A rather crude way of getting all of the data would be to utilize the following:
sp_msforeachdb 'SELECT * FROM sys.filegroups'
Another method might include the use of SSIS to loop through each database to procure that information.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2011 at 8:06 pm
Read this blog I wrote.. list-of-all-data-and-log-files-of-a-sql-instance[/url]
Modify the column names to fit your need.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 16, 2011 at 7:44 am
Hey Bru, I thought of a similar reference at first. It appears that the OP is looking for the filegroup information and not the file info.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2011 at 8:25 pm
Yes Jason, I did not look at the column GroupName that OP requested.. Thanks for pointing that out..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply