Active IQ Unified Manager Discussions

WFA- Volume efficiency query

CAPATEL_NET1984
1,926 Views

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
1,833 Views

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

geringer
1,901 Views

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

MattInCO
1,834 Views

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

 

Public