Data Infrastructure Management Software Discussions

Highlighted

WFA- Volume efficiency query

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?

 

2 REPLIES 2
Highlighted

Re: WFA- Volume efficiency query

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

Highlighted

Re: WFA- Volume efficiency query

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

Try the NEW Support Site!
NetApp Support Site
Forums