The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to register at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

WFA- Volume efficiency query

CAPATEL_NET1984

I am able to find a command to apply volume efficiecy policy to a particular volume in C mode. is there a query someone have so I can list all efficiecy policy for a cluster?

 

1 ACCEPTED SOLUTION

MattInCO

Would something like this do what you want?

 

SELECT
efficiency_policy.name as name,
vserver.name as "vserver.name",
cluster.primary_address AS 'vserver.cluster.primary_address'
FROM
cm_storage.cluster,
cm_storage.vserver,
cm_storage.efficiency_policy
WHERE
efficiency_policy.vserver_id = vserver.id
AND vserver.cluster_id = cluster.id
AND cluster.name = '${cluster}'
ORDER BY
efficiency_policy.name,
vserver.name,
cluster.primary_address

 

View solution in original post

2 REPLIES 2

MattInCO

Would something like this do what you want?

 

SELECT
efficiency_policy.name as name,
vserver.name as "vserver.name",
cluster.primary_address AS 'vserver.cluster.primary_address'
FROM
cm_storage.cluster,
cm_storage.vserver,
cm_storage.efficiency_policy
WHERE
efficiency_policy.vserver_id = vserver.id
AND vserver.cluster_id = cluster.id
AND cluster.name = '${cluster}'
ORDER BY
efficiency_policy.name,
vserver.name,
cluster.primary_address

 

View solution in original post

geringer

The Efficiency policies are in the WFA cach db.  Look at cm_storage.Efficiency_Policy

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public