DX Infrastructure Manager

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  [database probe] exclude items on configuration file from cfx custom file

    Posted 04-05-2014 12:35 AM

    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.



  • 2.  Re: [database probe] exclude items on configuration file from cfx custom file
    Best Answer

    Posted 04-07-2014 04:45 PM

    If you are trying to remove an entire section from the config file rather than individual keys, you have to use the "clear" tag rather than "delete". If you switch your config to "<excludes> clear", you should be able to skip all of the individual exclude entries from the CFX file.

     

    Here is a brief example to illustrate the difference between the tags...

     

    Config before:

     

    <setup>
       loglevel = 0
    </setup>
    <profiles>
       <server1>
          active = yes
          ip = 192.168.0.11
       </server1>
       <server2>
          active = yes
          ip = 192.168.0.12
       </server2>
       <server3>
          active = yes
          ip = 192.168.0.13
       </server3>
       <server4>
          active = yes
          ip = 192.168.0.14
       </server4>
    </profiles>

    CFX file:

     

    <profiles>
       <server1> delete
       </server1>
       <server2> delete
          ip =
       </server2>
       <server3> clear
       </server3>
    </profiles>

     Config after applying CFX file:

     

    <setup>
       loglevel = 0
    </setup>
    <profiles>
       <server1>
          active = yes
          ip = 192.168.0.11
       </server1>
       <server2>
          active = yes
       </server2>
       <server4>
          active = yes
          ip = 192.168.0.14
       </server4>
    </profiles>

     



  • 3.  Re: [database probe] exclude items on configuration file from cfx custom file

    Posted 04-07-2014 05:57 PM
    Many thanks!!! The "clear" tag is what I needed...

    Sincerely,
    Romolo