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

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

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

Applicable CAST Version
Release
Yes/No
8.3.x(tick)  
8.2.x (tick) 
8.1.x (tick) 
8.0.x (tick) 
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS2 (tick) 


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