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?

[geringer]

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

[MattInCO · Accepted solution]

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