Active IQ Unified Manager Discussions

Model and OS specific volume and aggregate max sizes in WFA

kiessl
4,510 Views

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

6 REPLIES 6

trentino123
4,490 Views

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
4,468 Views

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
4,454 Views

 

 

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
4,431 Views

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
4,429 Views

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
4,380 Views

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

Public