Purpose of Query
This query retrieve all the objects of all the analyzed applications for all the snapshots, this should be run on the local (Analysis Service database) and central (Dashboard Service database)schema.
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS | |
Query for CSS
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
Query result example
"Computed on 201612191550";"application_new";"application_new full content";"nbCheckListener";"[C:\CASTMS\Deploy\application_new\cpp\src\GUI\CapWindow.h].[CapWindow].[nbCheckListener()]";"C_METHOD";"C:\CASTMS\Deploy\application_new\cpp\src\GUI\CapWindow.h"
Query result interpretation
The above result represent the first line of the result query, in this example the object "nbCheckListener" its part of the application "application_new", it was computed by the snapshot "Computed on 201612191550", the object is part of the module "application_new full content" and he gave the following path "C_METHOD";"C:\CASTMS\Deploy\application_new\cpp\src\GUI\CapWindow.h"
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
