Configuration Value Method

-- Check the existing configuration listing so that you can choose to edit an existing one or adding a new one
-- When adding a new one, select a new name for the new configuration that does not conflict with an existing configuration.
select * from [CxDB].[Config].[CxEngineConfiguration];
 
-- EDIT
-- Check the database for the flag ID that needs to change
select * FROM [CxDB].[Config].[CxEngineConfigurationKeysMeta] where KeyName = 'PREDEFINED_FILE_EXCLUSIONS_MODES'

update [CxDB].[Config].[CxEngineConfigurationValues] 
set ConfigurationKeyId = <FlagId>, Value = '<list of IDs to exclude>'
where ConfigurationId = <configId>

-- CREATE
-- Create a new Default configuration with a custom name ( your choice ). Adding a 0 signals a non-default configuration.
insert into [CxDB].[Config].[CxEngineConfiguration]
values ('<SET A NAME FOR THE CONFIG>', 0)

-- Get the new configuration ID from the list
select * from [CxDB].[Config].[CxEngineConfiguration];

-- Check the database for the flag ID that needs to change
select * FROM [CxDB].[Config].[CxEngineConfigurationKeysMeta] where KeyName = 'PREDEFINED_FILE_EXCLUSIONS_MODES'
 
-- Set the new value of the flag
insert into [CxDB].[Config].[CxEngineConfigurationValues] values (<configId>, <FlagId>, '<list of IDs to exclude>')

--Check if the flag configuration was added to the new custom configuration
select * from [CxDB].[Config].[CxEngineConfigurationValues] where ConfigurationId = <configId>;

Create a new DefaultConfig.xml file in your Checkmarx SAST folder (example file path: <user>\AppData\Local\Checkmarx\Checkmarx SAST) with the following code:

<?xml version="1.0" encoding="windows-1252"?>
<Root_Element>
        <Configuration>
                <Key>PREDEFINED_FILE_EXCLUSIONS_ENABLED</Key>
                <Value>true</Value>
        </Configuration>
        <Configuration>
                        <Key>PREDEFINED_FILE_EXCLUSIONS_MODES</Key>
                        <Value>List of IDs</Value>
        </Configuration>
</Root_Element>

Example Configuration

For instance, if the configuration value is:

<Configuration>
    <Key>PREDEFINED_FILE_EXCLUSIONS_ENABLED</Key>
    <Value>true</Value>
</Configuration>
<Configuration>
        <Key>PREDEFINED_FILE_EXCLUSIONS_MODES</Key>
        <Value>1, 3, 9</Value>
</Configuration>

The following rules will be enabled:

All other rules will be disabled.