SQL Queries - Common SQL Queries - Queries on Objects - How to get the extract of the content of applications in all snapshots

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 , 
           rp.path 
FROM       <central_schema>.dss_objects art 
INNER JOIN <central_schema>.dss_object_info snap_art 
ON         snap_art.object_id = art.object_id 
INNER JOIN <central_schema>.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 <central_schema>.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 <central_schema>.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 <central_schema>.dss_objects module 
ON         module.object_id = l1.previous_object_id 
AND        module.object_type_id = 20000 
           /* functional module */ 
INNER JOIN <central_schema>.dss_object_info snap_module 
ON         snap_module.object_id = module.object_id 
AND        snap_module.snapshot_id = snap_art.snapshot_id 
INNER JOIN <central_schema>.dss_objects app 
ON         app.object_id = l0.previous_object_id 
AND        app.object_type_id = -102 
           /* application */ 
INNER JOIN <central_schema>.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       <central_schema>.dss_snapshots ds 
ON         ds.snapshot_id = snap_app.snapshot_id 
JOIN       <central_schema>.dss_translation_table dtt 
ON         dtt.object_id = art.object_id 
JOIN       <local_schema>.objfilref ofr 
ON         ofr.idobj = dtt.site_object_id 
JOIN       <local_schema>.refpath rp 
ON         rp.idfilref = ofr.idfilref 
ORDER BY   ds.snapshot_name , 
           app.object_full_name , 
           module.object_full_name, 
           art.object_name

Enter the SQL query

Enter the SQL query