SQL Queries - CAST Management Base - How to deactivate rules in the assessment model

 This page provides a query that allows you to deactivate rules in the assessment model

1. Run the following query on the management database, providing the list of the quality rules you wish to inactivate:

UPDATE cms_am_qual_rules
SET    active        =0
WHERE  metric_id IN (<list_of_your_qrs>);

For example the following are the list of the current quality rules associated with GreenIT:

20140522
20140523
20140524
20140525
20140526

2. Once the query has been run, open CAST-MS and put a check in the assessment model so that the quality rule is deactivated.

3. Once done. you can proceed with a snapshot without these quality rules.