Model and OS specific volume and aggregate max sizes in WFA

[kiessl]

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

[trentino123]

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.

[kiessl]

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

[trentino123]

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!

[kiessl]

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.

BR

Walter

[trentino123]

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.

[kiessl]

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