SQL Queries - CAST Central Base - Queries on Objects - How to get the LoC associated with an object in a specific snapshot

SELECT dos.object_id 
FROM   dss_objects dos 
JOIN   dss_object_info doi 
ON     doi.object_id = dos.object_id 
WHERE  dos.object_full_name = '<ObjectFullName>' 
AND    snapshotid =<snapshot_id>

SELECT metric_num_value 
FROM   dss_metric_results dmr 
JOIN   dss_object_info dos 
ON     dos.object_id = dmr.object_id 
JOIN   typ 
ON     idtyp = dos.object_type_id 
WHERE  dmr.metric_id = 10151 
AND    dmr.snapshot_id = 2 
AND    dos.snapshot_id = dmr.snapshot_id 
AND    dmr.metric_value_index= 1 
AND    dos.object_id = <object_id>

To be done

To be done