• 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)