SQL Queries - CAST Management Base - How to check if an assessment model data is loaded properly during snapshot
The purpose of this page is to provide queries to check if an assessment model data is loaded properly during snapshot.
To confirm if the assessment model data is properly loaded you can run the below query. You can try with any specific quality rule as shown below :
select * from cms_am_qual_rules where metric_id=<Quality_rule_id>;
If the data is loaded properly then you can see the quality rule result as below :
Otherwise, query will not provide any result.
Query will provide result of quality rule data if assessment model is loaded properly. If not, you will not be able to see any result for the above query.