7.2 Verify System Configurations

This topic provides information on verify system configurations.

The following script helps in listing the CM specific System Configurations:

SELECT dfrbcn.resource_value as "Property Name on System Configuration Screen", 
dfrbcd.resource_value as "Property Description on System Configuration Screen", 
dccab.module,substr(substr(dccab.prop_id,INSTR(dccab.prop_id,'.')+1),INSTR(substr(dccab.prop
_id,INSTR(dccab.prop_id,'.')+1),'.')+1) as "Property ID in the Database",dccab.prop_value as
 "Property Value in the Database", dccao.prop_value as"Overidden Property Value in the
 Database" from obdx_trunk_25ga.DIGX_CFG_CONFIG_ALL_B dccab left join 
obdx_trunk_25ga.DIGX_FW_RESOURCE_BUNDLE dfrbcn on dccab.prop_id =
 dfrbcn.resource_name and dfrbcn.bundle_name = 'ConfigName' left join 
obdx_trunk_25ga.DIGX_FW_RESOURCE_BUNDLE dfrbcd on dccab.prop_id = 
dfrbcd.resource_name and dfrbcd.bundle_name = 'ConfigDiscription' left join 
obdx_trunk_25ga.DIGX_CFG_CONFIG_ALL_O dccao on dccab.prop_id = 
dccao.prop_id and dccao.determinant_value = 'OBDX_BU' where dccab.sequence is null and dccab.module = 'cms';

Ensure correct values are maintained against the above properties. This maintenance can be done from the “System Configuration” admin screen or directly in DB schema.