CHANGE_EXCL_OBJ_DISCOVER_RULE

Change a discover rule in order to exclude objects from any object_group.

Parameter Name	Required	DefaultValue	Description
p_rule_id	yes		discover rule ID
p_schema_excl_pattern	no	.*	schema exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_object_excl_pattern	no	.*	object exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_comment_excl_pattern	no	.*	comment exclude pattern (null to keep unchanged, ‘ ‘ to clear value)
p_rule_comment	no		rule comment (null to keep unchanged, ‘ ‘ to clear value)

Example

In this example we modify the exclude discover rule number 5 by clear SCHEMA_EXCL_PATTERN and modify OBJECT_EXCL_PATTERN and leave COMMENT_EXCL_PATTERN and RULE_COMMENT unchanged.

EXECUTE SCRIPT api_scurty.change_excl_obj_discover_rule
           ( 5         -- p_rule_id
           , ' '       -- p_schema_excl_pattern
           , '.*_(DV|PV|PV2|HV|CV|CVR|FV|DEL|LV\d{1,}|HT|CTL|ERR|MT|LT\d{1,})' -- p_object_excl_pattern
           , NULL      -- p_comment_excl_pattern
           , NULL      -- p_rule_comment
           );