Disk Space Usage Report

Question

Disk Space Usage Report

Amit Raut

SSCrazy

Points: 2613
More actions
October 15, 2013 at 5:28 pm

#283899

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 1

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Amit Raut SSCrazy Points: 2613 More actions · Answer 2

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?

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 3

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Amit Raut SSCrazy Points: 2613 More actions · Answer 4

Oh, OK! Let me consult my architect and figure out the best solution. Thanks Jeff!