Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Disk Space Usage Report Expand / Collapse
Author
Message
Posted Tuesday, October 15, 2013 5:28 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Hi,

Has anybody worked on Disk Space Usage Report in SSRS 2005?

The requirement is to have a report that will display free vs total space for each drive on server (and on remote servers too, if possible). The report will have pie chart for each drive (The way it used to be in 'My Computer' in earlier versions of Windows).

Just wanted to know if anyone has the query ready before me re-inventing the wheel.

Thanks
Post #1505023
Posted Tuesday, October 15, 2013 6:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:55 PM
Points: 35,618, Visits: 32,214
Amit Raut (10/15/2013)
Hi,

Has anybody worked on Disk Space Usage Report in SSRS 2005?

The requirement is to have a report that will display free vs total space for each drive on server (and on remote servers too, if possible). The report will have pie chart for each drive (The way it used to be in 'My Computer' in earlier versions of Windows).

Just wanted to know if anyone has the query ready before me re-inventing the wheel.

Thanks


My personal feeling is that Pie charts take up too much space for what they do, are difficult to annotate properly, and make you have to carefully look at or even study the chart to figure out if something is out of spec. Horizontal % barometers make more sense to me but, even more than that, a nice table of values with Red, Orange, and Yellow highlighted cells is extraordinarly easy to recognize problem areas in a very quick scan, provides all the information you need in a comparatively very compact reporting format, and, my most favorite reason of all {drum roll please}, doesn't require me to even go near SSRS.

If you do it right, it'll even help you find "lost" CD's and DVD's that you left in a machine somewhere. I color those Green just to make them obvious.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1505031
Posted Tuesday, October 15, 2013 7:41 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Agreed Jeff! That could be the reason why Microsoft also changed pie-charts to display disk status in 'My Computer' .

Well, do you have any SQL script for getting the status?
Post #1505045
Posted Wednesday, October 16, 2013 7:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:55 PM
Points: 35,618, Visits: 32,214
Amit Raut (10/15/2013)
Agreed Jeff! That could be the reason why Microsoft also changed pie-charts to display disk status in 'My Computer' .

Well, do you have any SQL script for getting the status?


I do... but most people won't use it because it calls PowerShell using xp_CmdShell to get at WMI functionality. I'm one of those folks that don't believe in the myth that disabling xp_CmdShell provides any additional security except maybe for a 3ms burp in a hacker's attack engine.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1505214
Posted Wednesday, October 16, 2013 9:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Oh, OK! Let me consult my architect and figure out the best solution. Thanks Jeff!
Post #1505294
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse