Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Disk Space Usage Report


Disk Space Usage Report

Author
Message
Amit Raut
Amit Raut
SSC Eights!
SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)

Group: General Forum Members
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
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45135 Visits: 39923
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Amit Raut
Amit Raut
SSC Eights!
SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)

Group: General Forum Members
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?
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45135 Visits: 39923
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Amit Raut
Amit Raut
SSC Eights!
SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)

Group: General Forum Members
Points: 827 Visits: 342
Oh, OK! Let me consult my architect and figure out the best solution. Thanks Jeff!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search