SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects that are part of the action plan for a given snapshot

Purpose of Query

This page list the objects that are part of the Action Plan

Applicable CAST Version

Release	Yes/No
8.3.x	✅
8.2.x	✅
8.1.x	✅
8.0.x	✅

Applicable RDBMS

RDBMS	Yes/No
Oracle Server	✅
Microsoft SQL Server	✅
CSS2	✅

Query for CSS

SELECT dos.object_id, 
       dos.object_name 
FROM   dss_object_info doi 
JOIN   viewer_action_plans vap 
ON     doi.object_id = vap.object_id 
AND    doi.snapshot_id = <snapshot_id> 
JOIN   dss_objects dos 
ON     vap.object_id = dos.object_id 
AND    dos.object_id = doi.object_id

Query result example

1; object_full_name

Query result interpretation

The query returns the object Id and the object full name

Query for Oracle

SELECT dos.object_id, 
       dos.object_name 
FROM   dss_object_info doi 
JOIN   viewer_action_plans vap 
ON     doi.object_id = vap.object_id 
AND    doi.snapshot_id = <snapshot_id> 
JOIN   dss_objects dos 
ON     vap.object_id = dos.object_id 
AND    dos.object_id = doi.object_id

Query result example

1; object_full_name

Query result interpretation

The query returns the object Id and the object full name

Query for SQL server

SELECT dos.object_id, 
       dos.object_name 
FROM   dss_object_info doi 
JOIN   viewer_action_plans vap 
ON     doi.object_id = vap.object_id 
AND    doi.snapshot_id = <snapshot_id> 
JOIN   dss_objects dos 
ON     vap.object_id = dos.object_id 
AND    dos.object_id = doi.object_id

Query result example

1; object_full_name

Query result interpretation

The query returns the object Id and the object full name

Notes/comments

Related Pages