Subscribe
Accepted Solution

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?

 

Re: WFA- Volume efficiency query

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

Re: WFA- Volume efficiency query

[ Edited ]

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