SQL Queries - CAST Management Base - How to check if an assessment model data is loaded properly during snapshot

Purpose of Query

The purpose of this page is to provide queries to check if an assessment model data is loaded properly during snapshot.

Applicable CAST Version

Applicable RDBMS

Query for CSS

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>;

Query result example

If the data is loaded properly then you can see the quality rule result as below :

Otherwise, query will not provide any result.

Query result interpretation

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.

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages