How to alter quality rule weight?

In some upgrade process, users want getting violations on new quality rules but without impacting the health factors. At least not right away, the user prefer learn about the new added violation before accepting the change that can be apported to the Health factor. 

The solution is to put the weight of the qualty rules to zero. We can do so from CMS, but there is 2 raisons to think about alternative solutions:

1. Depending to the number of applications and the panel of technologies involved in this applicaions, we can have lot of quality rules on which we will apply this process!

2. What if we want to go back to the original assesmenet model? Its more safe to have the original assesement model and the customized one

For that we suggest you the following methode:

1. Alter the weight of the metric type trees of all the quality rules in question, for example on a on a single quality rule we will run the following on the central schema:

UPDATE
dss_metric_type_trees
SET aggregate_weight = <New weight > -- 0 For example
WHERE metric_id = <Metric id value>   --1101016 For example

2. Import the assesment model from the central schema, this action will ensure us to preserve the original assesement model as well as the customyzed one

3. Compute the snapshot