SQL Queries - CAST Central Base - Queries on Metrics - How to get the violation list of objects for a given quality rule per application module and snapshot

SELECT     ds.snapshot_name , 
           app.object_full_name    AS application_full_name, 
           module.object_full_name AS module_full_name , 
           art.object_name         AS artifact_name , 
           art.object_full_name    AS artifact_full_name , 
           typ.typnam              AS artifact_type 
FROM       dss_objects art 
INNER JOIN dss_object_info snap_art 
ON         snap_art.object_id = art.object_id 
INNER JOIN dss_link_info l2 
ON         l2.next_object_id = art.object_id 
AND        l2.link_type_id = 3 
AND        l2.snapshot_id = snap_art.snapshot_id 
INNER JOIN dss_link_info l1 
ON         l1.next_object_id = l2.previous_object_id 
AND        l1.link_type_id = 1 
AND        l1.snapshot_id = l2.snapshot_id 
INNER JOIN dss_link_info l0 
ON         l0.next_object_id = l1.previous_object_id 
AND        l0.link_type_id = 1 
AND        l0.snapshot_id = l1.snapshot_id 
INNER JOIN dss_objects module 
ON         module.object_id = l1.previous_object_id 
AND        module.object_type_id = 20000 
           /* functional module */ 
INNER JOIN dss_object_info snap_module 
ON         snap_module.object_id = module.object_id 
AND        snap_module.snapshot_id = snap_art.snapshot_id 
INNER JOIN dss_objects app 
ON         app.object_id = l0.previous_object_id 
AND        app.object_type_id = -102 
           /* application */ 
INNER JOIN dss_object_info snap_app 
ON         snap_app.object_id = app.object_id 
AND        snap_app.snapshot_id = snap_art.snapshot_id 
INNER JOIN typ 
ON         typ.idtyp=art.object_type_id 
JOIN       dss_snapshots ds 
ON         ds.snapshot_id = snap_app.snapshot_id 
JOIN       dss_metric_results dmr 
ON         dmr.snapshot_id = snap_app.snapshot_id 
AND        dmr.object_id = art.object_id 
AND        dmr.metric_value_index = 1 
AND        dmr.metric_id = <metric_id> +1 
           --- WHERE ds.snapshot_id =  ---Activate this line if you want to restrict the query to only one snpashot 
ORDER BY   ds.snapshot_name , 
           app.object_full_name , 
           module.object_full_name, 
           art.object_name