Purpose of Query
To identify all the objects involved in AFP modification for specific snapshot and for all applications.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3,x | |
8.2,x | |
8.1,x | |
8.0,x | |
7.3.x | |
7.2.x | |
7.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 | |
CSS1 |
Query for CSS
Query for Oracle
The query is to identify all the objects invoved in AFP modification for all the snapshots and for all applications.
Replace the [CB Schema] and [Snapshot ID] with desired Central Base and SnapshotID :
select distinct dost.OBJECT_ID as "Modified Transaction ID", dost.OBJECT_NAME as "Modified Transaction Name", dos.OBJECT_ID as "Modified Object ID", dos.OBJECT_NAME as "Modified Object Name", dos.OBJECT_FULL_NAME as "Modified Object Full Name", dot.OBJECT_TYPE_ID as "Modified Object Type ID", dot.OBJECT_TYPE_NAME as "Modified Object Type Name" from (select dlic.SNAPSHOT_ID, dlic.PREVIOUS_OBJECT_ID as TRANSACTION_ID, dlic.NEXT_OBJECT_ID as OBJECT_ID, dlic.LINK_TYPE_ID from [CB Schema].DSS_LINK_INFO dlic where dlic.LINK_TYPE_ID in (11000, 11001, 11002, 11003, 11004) ) dlic join [CB Schema].DSS_OBJECTS dos on dos.OBJECT_ID = dlic.OBJECT_ID join [CB Schema].DSS_OBJECT_TYPES dot on dot.OBJECT_TYPE_ID = dos.OBJECT_TYPE_ID join [CB Schema].DSS_OBJECTS dost on dost.OBJECT_ID = dlic.TRANSACTION_ID join [CB Schema].DSS_OBJECT_INFO doic on doic.SNAPSHOT_ID = dlic.SNAPSHOT_ID and doic.OBJECT_ID = dlic.OBJECT_ID join [CB Schema].DSS_APP_STATUSES das on das.SNAPSHOT_ID = dlic.SNAPSHOT_ID join [CB Schema].DSS_OBJECT_INFO doip on doip.SNAPSHOT_ID = das.PREVIOUS_SNAPSHOT_ID and doip.OBJECT_ID = doic.OBJECT_ID and doip.OBJECT_CHECKSUM != doic.OBJECT_CHECKSUM join [CB Schema].DSS_LINK_INFO dlip on dlip.SNAPSHOT_ID = doip.SNAPSHOT_ID and dlip.PREVIOUS_OBJECT_ID = dlic.TRANSACTION_ID and dlip.NEXT_OBJECT_ID = dlic.OBJECT_ID and dlip.LINK_TYPE_ID = dlic.LINK_TYPE_ID where dlic.SNAPSHOT_ID = [Snapshot ID]
Query for SQL server
Notes/comments
Reference webcall 28529 ,29087
Query result example
Related Pages