Get a Count of all Objects in TRIRGA 9

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.


SELECT
spec_template_id,
type_name,
COUNT(1) COUNT
FROM
ibs_spec
GROUP BY spec_template_id, type_name
ORDER BY 3 DESC