topic Re: Model and OS specific volume and aggregate max sizes in WFA in Active IQ Unified Manager Discussions

Model and OS specific volume and aggregate max sizes in WFA

kiessl — Thu, 05 Jun 2025 05:18:12 GMT

Hi,

I need to know the model and os specific maximum volume and aggregate size in a WFA (3.0) workflow and/or (powershell based) command.

How to get this info from WFA/cluster/node?

Thanks in advance.

Walter

Re: Model and OS specific volume and aggregate max sizes in WFA

trentino123 — Tue, 13 Jan 2015 17:25:43 GMT

Hi,

In order to view the aggregates in the cluster with the most space, you could use this user input query for the $aggregate variable :

SELECT
name,available_size_mb
FROM
cm_storage.aggregate
ORDER BY
available_size_mb
DESC

You can also anidate this query to another database to also get the node name, like with this query:

SELECT
aggregate.name as 'aggregate_name',
aggregate.available_size_mb,
node.name
FROM
cm_storage.node as node,
cm_storage.aggregate as aggregate
WHERE
aggregate.node_id = node.id
ORDER BY
aggregate.available_size_mb
DESC

This query can be used in a dropdown but also for a filter/finder to automatically choose an aggregate ( those filters already exist ).

Hope that helps.

Thanks.

Re: Model and OS specific volume and aggregate max sizes in WFA

kiessl — Wed, 14 Jan 2015 10:21:38 GMT

Hi Trentino123,

thanks for the answer. But this is not what I need.

When I create a FlexVol of size 150TB then this fails on certain models with certain operating system versions because this is larger than the maximum FlexVol size for this model/os. I want to know this limit within WFA/WFA-command before creating such a big volume rather than breaking the command/workflow.

Best Regards

Walter

Re: Model and OS specific volume and aggregate max sizes in WFA

trentino123 — Wed, 14 Jan 2015 17:23:01 GMT

It is a small change from the last query to include the node OS and the node model.

SELECT
aggregate.name as 'aggregate_name',
aggregate.available_size_mb,
node.name,
node.model,
node.os_version
FROM
cm_storage.node as node,
cm_storage.aggregate as aggregate
WHERE
aggregate.node_id = node.id
AND
( node.model LIKE '%8040%' OR node.model LIKE '%3250%' )
AND
( node.os_version LIKE '%8.3.0%' OR node.os_version LIKE '%8.2.0%' )

AND

aggregate.available_size_mb > 150000
ORDER BY
aggregate.available_size_mb
DESC

Hope that works!

Thanks!

Re: Model and OS specific volume and aggregate max sizes in WFA

kiessl — Fri, 16 Jan 2015 11:08:46 GMT

Trentino123,

please correcte me if I am wrong:

Your query results in all existing aggregates of specific models or operating system versions which have more than 150.000 GB space available.

Walter

Re: Model and OS specific volume and aggregate max sizes in WFA

trentino123 — Fri, 16 Jan 2015 12:35:46 GMT

Hi Walter,

Yes, it will show you aggregates ordered from higher to lower with more than 150Tb ( that could be taken out of the query if you don't need it ), of specific OS's and models.

Let me know if you need anything else.

Thanks,

Trentino123.

Re: Model and OS specific volume and aggregate max sizes in WFA

kiessl — Thu, 05 Feb 2015 07:10:35 GMT

Hi Trentino123,

I do not understand how this would solve my problem. Please explain, how I can get the model and oerating specifc absolut volume size with this query.

Is there anybody else who can contribute to this discussion? Perhaps some NetApp developers?

Best Regards