The script below can be used to get a list of all objects in your TRIRIGA database, showing the objects with the greatest record counts first. This can be useful to identify which records are consuming all of the space in your database, especially ones that have no business value for you.
This script should be run against your tridata schema.
GROUP BY spec_template_id, type_name
ORDER BY 3 DESC