AnsweredAssumed Answered

[database probe] exclude items on configuration file from cfx custom file

Question asked by romolo on Apr 5, 2014
Latest reply on Apr 7, 2014 by romolo

Hi all,

I've noted that on new version of an database probe (oracle/sqlserver) at header exist an "delete" argument after the tag.

Based on this, i've tried to delete obsolete tresholds and exclude lists using distribute process with some like this:

<checkpoints> overwrite
   <database_state> overwrite
      active = yes
      description = Monitors database state
      qos = yes
      qos_list = yes
      clear_msg = database_state_1
      clear_sev = clear
      scheduling = rules
      condition = !=
      column = state
      key = $object
      samples = 5
      exclude_defs = yes
      include_defs = yes
      use_exclude = no
      use_include = no
      msg_variables = $check.x;$profile.x;$instance.x;$object.c;$state.i;$state_desc.x
      type = 2
      interval = 1 min
      sql_timeout = 2 min
      <excludes> delete
         <0> delete
            pattern = ProjectServer_Reporting_SP
         </0>
         <1> delete
            pattern = ProjectServer_Reporting_SharepointB2W
         </1>
         <2> delete
            pattern = ProjectServer_Reporting_INFRA
         </2>
         <3> delete
            pattern = ProjectServer_Published_INFRA
         </3>
         <4> delete
            pattern = ProjectServer_Draft_SP
         </4>
         <5> delete
            pattern = ProjectServer_Draft_SharepointB2W
         </5>
         <6> delete
            pattern = ProjectServer_Draft_INFRA
         </6>
         <7> delete
            pattern = ProjectServer_Archive_SP
         </7>
         <8> delete
            pattern = ProjectServer_Archive_SharepointB2W
         </8>
         <9> delete
            pattern = ProjectServer_Archive_INFRA
         </9>
      </excludes>
      <qos_lists> overwrite
         <0> overwrite
            qos_name = database_state
            qos_desc = SQL Server Database State
            qos_unit = State
            qos_abbr = State
            qos_value = state
            qos_key = $object
            qos_max =
         </0>
      </qos_lists>
      <thresholds> overwrite
         <default> overwrite
            <0> overwrite
               tagid = 0
               value = 0
               unit = minutes
               sev = critical
               msg = database_state_2
               condition = !=
               clear_msg = database_state_1
               scheduling = rules
               key_col_name =
               key_col_value = default
            </0>
         </default>
      </thresholds>
   </database_state>
</checkpoints>

 

This have installed successfully and the "pattern" was cleared but the sequencer (id) stay in configuration.

Anyone got success on remove all tresholds/messages/exclude/include from an checkpoint based on a single "fix" configuration file (oracle_monitor.cfx / sqlserver_monitor.cfx) ??

 

Sincerely,

Romolo.

Outcomes