Quick query checks on snapshot results – a little more detail

This is a follow up to the quick query checks on snapshot results  post.  If you want to get a little more detail on your snapshot checking between two specific snapshots, you can use the following queries to check the object types and link types in each snapshot to see how they compare.

Query to provide a list of object types for two snapshots for comparison on the central database (substitute your snapshot_ids to compare in the query below):

select count(*), object_type_id, snapshot_id from dss_object_info where snapshot_id in (1, 2) group by object_type_id, snapshot_id order by object_type_id, snapshot_id;

Query to provide a list of link types types for two snapshots for comparison  on the central database (substitute your snapshot_ids to compare in the query below):

select count(*), link_type_id, snapshot_id from dss_link_info where snapshot_id in (1, 2)  group by link_type_id, snapshot_id order by link_type_id, snapshot_id;

Checking this information can give you a little more detail about the objects and links in each snapshot for comparison to each other to give some rough idea of the differences between the snapshots.

The object types can be found in the typ table where the object_type_id corresponds to idtyp.

The link types are not as numerous but generally indicate the type of link between objects (parent/child, snapshot/module, etc.)  I’ll check into adding this information into the TKB.

For more detailed examination, please check the results in the dashboard and other CAST tools.