topic Re: CLI comparing values in ONTAP Discussions

CLI comparing values

Guille — Wed, 04 Jun 2025 10:07:19 GMT

Hello everyone,
it is possible to list the volumes that it's -percent-used value is greater than -space-nearly-full-threshold-percent value?
As far as I know extended query will not be suitable to solve this question.

This could we great, but is not working for me:
vol show -percent-used > -space-nearly-full-threshold-percent
Error: The expression is missing a value

Thank you much,
Guille.

Re: CLI comparing values

Ontapforrum — Wed, 15 Dec 2021 20:16:38 GMT

Not sure if your query is that straightforward.

By, default <-space-nearly-full-threshold-percent> value is 95% for Flexvols in ONTAP. If you are interested to know which volumes are past this %?

This command will list the volumes
::> vol show -percent-used > 95

If you aren't sure what's thresholds are, you can view them:
::> volume show -volume * -fields space-nearly-full-threshold-percent

Is that what you were looking for?

Re: CLI comparing values

Guille — Wed, 15 Dec 2021 21:09:45 GMT

Hi,
From my point of view this query is simple if it were possible to compare the value of an attribute with the value of another attribute of the same volume.
After reviewing the documentation related to the operators that can be used for this query, I deduce that this type of comparison is not possible with "ONTAP CLI"?

Re: CLI comparing values

parisi — Thu, 16 Dec 2021 14:23:45 GMT

That particular query isn't possible, afaik. But you can sort by a field with the -sort-by flag (advanced mode)

This has some examples, along with some other tips:

https://whyistheinternetbroken.wordpress.com/2015/02/16/techbecome-a-clustered-data-ontap-cli-ninja/

Re: CLI comparing values

Guille — Sun, 19 Dec 2021 19:08:24 GMT

Of course, volumes has a default value for a lot its properties, right by default, but this is not the case.
The posted query is an example ot the main question, as you can read on the posted title, it is about comparing values using CLI.
It makes sense that if an object, in this case a volume, has two propertie, it should be possible to compare this two values.
Now at days this is done exporting to xls and formuling A1 > B1, easy, but not possible from CLI.
An enhancement for a later version of ONTAP.
Thank you for your time in replying.

Re: CLI comparing values

Guille — Wed, 22 Dec 2021 16:54:17 GMT

Hi,
From my point of view this query is simple if it were possible to compare the value of an attribute with the value of another attribute of the same volume.

Re: CLI comparing values

Guille — Wed, 29 Dec 2021 18:55:26 GMT

That is not the question of the post. The CLI queries have a limitation, they cannot compare the value of two attributes of the same volume. Maybe nesting two queries with powershell is possible.
Thank you all for your time.