Looking for a report showing volumes/qtrees/quotas under and over committed

[korns]

Hi,

(NOTE: My context for this inquiry is "Clustered ONTAP" but I wonder if a 7-mode report exists ... and OCUM 5.1 on Linux)

My customer uses qtrees within volumes extensively and sets qtree-quotas to divide the space up inside volumes. They do not always have the qtree-quotas set correctly and they know they have some volumes that are over committed (example: a 100GB volume with 2 60GB qtree-quotas -> or over committed at 120%)  and some under committed (example: 100GB volume with 2 40GB qtree-quotas -> or under committed at 80% with 20GB unaccessible/wasted).

We found a "good" report to detect and report these situations called volumes-quota-committed (sample below -- run from CLI because I don't see it in the GUI Reports):

Object ID Volume            Aggregate Storage Server  Used         Committed    Committed (%) Total/Max Size

--------- ----------------- --------- --------------- ------------ ------------ ------------- --------------

3910      proj10010c        n04_sata  atxvs01            219495404    734003200         139.0      527958016

3943      proj6014c         n03_sas   atxvs01           1037216172   2097152000         111.1     1887436800

3941      proj6013c         n02_sas   atxvs01            729033860   2097152000         111.1     1887436800

3464      proj6008c         n02_sata  atxvs01               564352    104857600         105.3       99614720

3470      proj10009c        n02_sata  atxvs01             11196144    209715200         105.3      199229440

The "ideal" report would be like the above but after each volume, would list the qtrees and their quotas and usage so the decision can be made whether it makes more sense to change the size the volume or to change the size of one or more of the qtrees within. With the report above, there is more work involved to lookup that data in another report (qtree or quota report of via SysMan, etc). Something that might look like:

Object ID Volume            Aggregate Storage Server  Used         Committed    Committed (%) Total/Max Size

--------- ----------------- --------- --------------- ------------ ------------ ------------- --------------

3910      proj10010c        n04_sata  atxvs01            219495404    734003200         139.0      527958016

                              Qtree                    Space Limit

                              -------------------     ------------

                              qtreeNameOne                99999999

                              qtreeNameTwo                99999999

                              qtreeNameThree               9999999

3941      proj6013c         n02_sas   atxvs01            729033860   2097152000         111.1     1887436800

                              Qtree                    Space Limit

                              -------------------     ------------

                              qtreeNameOne                99999999

                              qtreeNameTwo                99999999

3464      proj6008c         n02_sata  atxvs01               564352    104857600         105.3       99614720

                              Qtree                    Space Limit

                              -------------------     ------------

... ETC ...

QUESTION: Is anyone aware of a standard or custom OCUM report, or even a report based on direct NMSDK calls, that provides something like this? (something Linux/bash/perl based that could be cron'ed is preferred)

All the reports I find seem to be flat reports about aggregates, volumes, qtrees or quotas but never a cascading report showing them nested within each other to address the above need.

We are considering taking some .txt or .csv output from a couple of standard OCUM reports and writing something custom but thought I'd check here first.  

[adaikkap · Accepted solution]

Hi David,

     This kind of reporting is not possible with OCUM. But the OnCommad Reports can do this as its a data warehouse solution. But unfortunately this OCR does not support clustered ontap. A later version of OCR will allow you to do the same.

Regards

adai

[korns]

Thanks Adai,

I ended up coming up with a shell script (kludge) that merges two (2) standard OCUM 5.1 Clustered Mode reports. They are the generated with:

   # dfm reports view volumes-quota-committed   ... which shows volumes over and under committed in related qtree quotas

   # dfm reports view qtrees-capacity                       ... which shows the qtress within the volumes and much much they are being used

The shell script generates these standard reports in comma separated (.csv) format and then use cat/grep/awk to merge them into something than can be further formatted in Excel. If I can figure out how to upload an attachment here I'll share.

Dave

[adaikkap]

Hi Dave,

     Use the Advance Editor on your top right of the reply window to upload stuffs.

Regards

adai