topic Re: WFA- Volume efficiency query in Active IQ Unified Manager Discussions

WFA- Volume efficiency query

CAPATEL_NET1984 — Wed, 04 Jun 2025 14:26:55 GMT

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

geringer — Tue, 24 Oct 2017 14:47:31 GMT

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

Re: WFA- Volume efficiency query

MattInCO — Wed, 25 Oct 2017 04:49:27 GMT

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