Purpose of Query
This page provides a query that allows you to deactivate rules in the assessment model
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 | |
CSS3 |
Query for CSS
- 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>);
Query result example
Indication of the number of rows updated by the above query
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.
Query for Oracle
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
Related Pages