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 ).
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.
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%' )
aggregate.available_size_mb > 150000 ORDER BY aggregate.available_size_mb DESC