Active IQ Unified Manager Discussions

Selecting volumes based on the percentage used

baileyj

Guys,

I'm looking to have a query select volumes based off the percentage used, all volumes 90% full and up for example.  Any ideas?  I've been beating this around for a while now and getting no traction so I figured I would ask the experts.

Thanks in Advance.

10 REPLIES 10

ag
NetApp

Hi Baileyj,

Did the query work out fine for you?

-Anil

ag
NetApp

My bad. Try this!

SELECT

    array.ip as 'array.ip',

    volume.name as name

FROM

    storage.volume as volume,

    storage.array as array

WHERE

    (

        (

            volume.used_size_mb/volume.size_mb

        ) * 100

    ) > '${Percentage}'

    AND array.id = volume.array_id

    AND array.ip = '${array}'

    AND volume.name != 'vol0'

ag
NetApp

Hi bailey,

This is the query i am using in the filter i created.

I was using a later version and forgot for a moment that you would not be able to import it.

SELECT

    array.ip as 'array.ip',

    volume.name as name

FROM

    storage.volume as volume,

    storage.array as array

WHERE

    (

        (

            volume.used_size_mb/volume.available_size_mb

        ) * 100

    ) > '${Percentage}'

    AND array.id = volume.array_id

    AND array.ip = '${array}'

    AND volume.name != 'vol0'

Let me know if it helps.

-Anil

baileyj

That helps, but it doesn't appear to be doing what I want. 

When I plug in a percentage I'm not just getting volumes of that percentage used or higher but I'm not getting all of the volumes either, what am I missing here?

ag
NetApp

Hi,

I have attached the filter.

Import and use it.

Let me know if it works fine.

Cheers,

Anil

baileyj

Thanks!  Can you post the code? I'm unable to upgrade to 2.2 until it goes GA so i can't use the one you attached.

sundarea

Anil G left the office for the day... he will post the code in couple of hours(once he reaches home).

baileyj

Great, thanks.

sundarea

HI Bailey,

We need to write a filter to list all the volumes based on used size. by the way are you looking for CDOT or 7-Mode. So that i can write a filter and share it with you.

Regards,

Sundar

baileyj

7-mode, thanks Sundar!

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public