Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
