SQL Queries - CAST Central Base - Queries on Objects - How to get the checksum of an object in a given snapshot based on its full name

This page provides you with the definition of the checksum value of an object, and how to get this value from the central base for a given snapshot

Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.

You can get the checksum value of an object in a given snapshot from the Central base as follows:

SELECT doi.object_checksum 
FROM   dss_object_info doi 
JOIN   dss_objects dos 
ON     dos.object_id = doi.object_id 
WHERE  dos.object_fullname = '<FULL_NAME>' 
AND    doi.snapshot_id = <SNAPSHOT_ID>

1933263931

Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.

You can get the checksum value of an object in a given snapshot from the Central base as follows:

SELECT doi.object_checksum 
FROM   dss_object_info doi 
JOIN   dss_objects dos 
ON     dos.object_id = doi.object_id 
WHERE  dos.object_fullname = '<FULL_NAME>' 
AND    doi.snapshot_id = <SNAPSHOT_ID>

245461564

Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.

You can get the checksum value of an object in a given snapshot from the Central base as follows:

SELECT doi.object_checksum 
FROM   dss_object_info doi 
JOIN   dss_objects dos 
ON     dos.object_id = doi.object_id 
WHERE  dos.object_fullname = '<FULL_NAME>' 
AND    doi.snapshot_id = <snapshot_id>

 245461564