Purpose of Query
This query lists violations details: Snapshot id, Module name, Rule Id, Rule Name, Rule Technology, object id, Object Name, Object Fullname, Object Type, Rule Criticality
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| CSS3 | |
| CSS2 | |
Query for CSS
SELECT dmr.snapshot_id AS "snapshot id",
dob.object_name AS "Module Name",
dmr.metric_id - 1 AS "metric ID",
dmt.metric_name AS "Quality rule name",
tech.techno_type_name AS "Quality rule technology",
dos.object_id AS "object id",
dos.object_name AS "object name",
dos.object_full_name "as object full name",
t.typdsc AS "object type name",
CASE DMTT.metric_critical
WHEN 1 THEN 'Critical'
WHEN 0 THEN 'Non Critical'
END AS "crtical"
FROM dss_metric_results dmr
JOIN dss_metric_types dmt ON dmt.metric_id = dmr.metric_id
JOIN dss_metric_type_trees DMTT ON DMTT.metric_id = DMT.metric_id
JOIN dss_objects dos ON dos.object_id = dmr.object_id
JOIN typ t ON t.idtyp = dos.object_type_id
JOIN dss_metric_types TMT ON TMT.metric_id = dmr.metric_id - 1
JOIN dss_metric_param_types PT ON PT.metric_id = TMT.metric_id
AND PT.param_index = 1
JOIN dss_techno_display_vw tech ON tech.techno_type_id = PT.object_type_id
JOIN dss_link_info dli ON dli.next_object_id = dmr.object_id
AND dli.snapshot_id = dmr.snapshot_id
AND dli.link_type_id = 3
JOIN dss_object_info doi ON doi.object_id = dli.previous_object_id
AND doi.snapshot_id = dli.snapshot_id
JOIN dss_technologies dtl ON dtl.module_type_id = doi.object_type_id
JOIN dss_link_info dliMF ON dliMF.next_object_id = dli.previous_object_id
AND dliMF.snapshot_id = dli.snapshot_id
AND dliMF.link_type_id = 1
JOIN dss_objects dob ON dob.object_id = dliMF.previous_object_id
AND dob.object_type_id = 20000
WHERE dtl.techno_type_id = PT.object_type_id
Query result example
1;"Selectif Backup full content";7784;"Avoid Artifacts with lines longer than X characters";"C++";7802;"Connect_server_button_Click";"[C:\CASTMS\Deploy\Selectif Backup\My Package\GUI\conectionProfileCreation.h].[ConnectionInterface].[Form1].[Connect_server_button_Click(System::Object*, System::EventArgs*)]";"C++ Method";"Non Critical"
Query result interpretation
The query returns Snapshot id, Module name, Rule Id, Rule Name, Rule Technology, object id, Object Name, Object Fullname, Object Type, Rule Criticality
Notes/comments
Related Pages
