How to manually examine for references to a Change Order (CO) having Configuration Item (CI) concerns.

Document ID : KB000030087
Last Modified Date : 14/02/2018
Show Technical Document Details

DESCRIPTION:

I am suspecting I have CO's that are incorrectly represented in terms of the "has_CI" flag.  Such a flag is used to determine if a CO has any associated CI's attached and is used in scoreboards, such as the default .  How do I check?

 

SOLUTION:

One can run the following pdm_extract commands from the CA Service Desk (CA SDM) server:

1.  A list of all active CO's whose "has_CI" field is 0:
 
  pdm_extract -c -f "Select id, chg_ref_num, has_CI from Change_Request where active_flag = 1 and has_CI=0" > CO-CI-0.dat
 
2.  A list of all active CO's whose "has_CI" field is NULL:
 
  pdm_extract -c -f "Select id, chg_ref_num, has_CI from Change_Request where active_flag = 1 and has_CI IS NULL" > CO-CI-NULL.dat
 
3.  A list of all active CO's whose "has_CI" field is 1:
 
  pdm_extract -c -f "Select id, chg_ref_num, has_CI from Change_Request where active_flag = 1 and has_CI=1" > CO-CI-1.dat
 
4.  A list of all CO/CI pairings that currently exist.
 
 pdm_extract -c usp_lrel_asset_chgnr > usp_lrel_asset_chgnr.dat

The idea is to compare the id numbers in the extract files from Change_Requests, depending on scenario. 

For instance, to find all CO's that are not flagged as having a CI (has_CI = 0) but there is a list present, one can run the first and fourth query and compare CO id numbers across the two.