Client Automation - Incorrect number of violators in evaluation of a Software Policy

book

Article ID: 205633

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Software Delivery

Issue/Introduction

Evaluation of a Software Policy does not give correct number of violators.
Some computers are missing in violator folder and is not present in the SD Job Container.
 

Cause

This problem could occur if there is an inconsistency in mdb database. Status of a SD activity is still active but its linked SD Job Container is in terminated status (OK or ERROR). 

 

Environment

Client Automation 14.0

 

Resolution

Execute following SQL Query to find the name of SD Job Container with problem :


use mdb

select jc.name from usd_job_cont jc, usd_link_jc_act l, usd_activity a
where jc.type=3 and jc.name <>'__SD_Jobs' and jc.state in (6,7,8) and jc.objectid=l.jcont and l.activity=a.objectid
and a.state=1



Delete the job container returned by this query in DSM Explorer.