SQL Queries - CAST Central Base - Queries on snapshots - How to get the number of SQL tables for a given snapshot

SELECT ds.SNAPSHOT_NAME AS "Snapshot" ,
dot.OBJECT_TYPE_NAME AS "Object Type" ,
COUNT(doi.OBJECT_ID) AS "Objects Count",
CASE
WHEN dli.LINK_TYPE_ID = -3
THEN 'External'
WHEN dli.LINK_TYPE_ID = 3
THEN 'Internal'
ELSE 'Error'
END AS "Status"
FROM DSS_SNAPSHOTS ds
JOIN DSS_OBJECT_INFO doi
ON doi.SNAPSHOT_ID = ds.SNAPSHOT_ID
JOIN DSS_OBJECT_TYPES dot
ON dot.OBJECT_TYPE_ID = doi.OBJECT_TYPE_ID
JOIN DSS_LINK_INFO dli
ON dli.NEXT_OBJECT_ID = doi.OBJECT_ID
AND dli.SNAPSHOT_ID = ds.SNAPSHOT_ID
AND dli.LINK_TYPE_ID IN (-3,
3)
WHERE dot.OBJECT_TYPE_NAME LIKE 'SQL Table%'
AND ds.SNAPSHOT_NAME LIKE '<SNAPSHOT NAME>'
GROUP BY ds.SNAPSHOT_NAME ,
ds.SNAPSHOT_DATE ,
dot.OBJECT_TYPE_NAME,
dli.LINK_TYPE_ID
ORDER BY ds.SNAPSHOT_DATE ,
dot.OBJECT_TYPE_NAME,
dli.LINK_TYPE_ID
 
Here replace <SNAPSHOT NAME> with the snapshot name in which you are interested.

TBD

Same as CSS2