Dynamic groups and Query Based Policies evaluated very frequently

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

If a dynamic group or a "Query Based" policy has no Engine and frequency period set for the evaluation, it is evaluated very frequently (every time a Collect job is executed by one Engine).

This could generated a lot of problems like :

- Overall performance degraded
- Crash of process cmengine.exe and/or amobjectmanager.exe

Environment

Client Automation - All Versions.

Resolution

For Dynamic Group :

1. You could execute following SQL Query to find dynamic groups without engine or frequency for evaluation :
   
   SELECT g.label GroupName, q.label QueryName, e.label EngineName, g.eval_freq
   FROM ca_group_def g LEFT OUTER JOIN ca_engine e ON g.evaluation_uuid=e.engine_uuid, ca_query_def q
   WHERE q.query_uuid=g.query_uuid and (g.evaluation_uuid is NULL or (g.evaluation_uuid is NOT NULL and g.eval_freq=0))
   ORDER BY 3,1,2
   
   Example :
   
   
   
   In example above, dynamic group GROUP2 has no Engine and evaluation frequency set.
   
   
   
2. In DSM Explorer open the properties of the group GROUP2 and assign an Engine and Evaluation period for the Query evaluation.
   
   
   
   
3. Repeat the step 2 for all groups returned by the SQL Query

Remark :
Sometimes it could be difficult to find the group if there are a lot of groups and subgroups
You could use this article to help you to find the group :

Query to list hierarchy of ITCM Groups

For "Query Based" Policy :

1. You could execute following SQL Query to find dynamic groups without engine or frequency for evaluation :
   
   SELECT g.polname PolicyName, q.label QueryName, e.label EngineName, g.eval_freq
   FROM polidef g LEFT OUTER JOIN ca_engine e ON g.evaluation_uuid=e.engine_uuid, ca_query_def q
   WHERE q.query_uuid=g.query_uuid and g.polid>0 and (evaluation_uuid is NULL or (evaluation_uuid is NOT NULL and eval_freq=0))
   ORDER BY 3,1,2
   
   
   
   In example above, Policy TEST1 has no Engine and no evaluation frequency set.
   
   
   
2. In DSM Explorer open the properties of the Query Based Policy and assign an Engine and Evaluation period for the Query evaluation.
   
   
   
   
   
3.  Repeat the step 2 for all policies returned by the SQL Query