6.2 Verify System Configurations

This topic provides information on verify system configurations.

The following script helps in listing VAM specific System Configurations:

SELECT dfrbcn.resource_value as "Property Name on System Configuration Screen", 
dfrbcd.resource_value as "Property Description on System Configuration Screen", 
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 DIGX_CFG_CONFIG_ALL_B dccab 
left join DIGX_FW_RESOURCE_BUNDLE dfrbcn 
on dccab.prop_id = dfrbcn.resource_name and dfrbcn.bundle_name = 'ConfigName' 
left join DIGX_FW_RESOURCE_BUNDLE dfrbcd 
on dccab.prop_id = dfrbcd.resource_name and dfrbcd.bundle_name = 'ConfigDiscription' 
left join DIGX_CFG_CONFIG_ALL_O dccao 
on dccab.prop_id = dccao.prop_id and dccao.determinant_value = '{{determinant_value}}'
--Please enter correct determinant value
where dccab.sequence != '-1' and dccab.module = 'vam';

Ensure that the correct values are maintained against the above properties.

This maintenance can be done from the “System Configuration” admin screen or directly in DB schema.