# Generic select count(*) from# Exceptions both default and custom count # Group select count(*) from dm_group where group_name not like 'dm_%' and group_name not like ' ' select count(*) from dm_group where group_name like 'dm_%' select count(*) from dm_group where group_name like ' ' # ACL select count(*) from dm_acl where object_name like 'dm_%' select count(*) from dm_acl where object_name not like 'dm_%' select count(*) from dm_acl where object_name like 'acl_%' select count(*) from dm_acl where object_name not like 'acl_%' and object_name not like 'dm_%' # Alias Set select count(*) from dm_alias_set # Job select count(*) from dm_job where object_name like 'dm_%' select count(*) from dm_job where object_name not like 'dm_%' # Method select count(*) from dm_method where object_name not like 'dm_%' select count(*) from dm_method where object_name like 'dm_%' # Lifecycle select count(*) from dm_policy # Registered Tables select count(*) from dm_registered where object_name not like 'dm%' order by object_name select count(*) from dm_registered where object_name like 'dm%' order by object_name # Relation select count(*) from dm_relation where relation_name not like 'dm%' select count(*) from dm_relation where relation_name like 'dm%' # Type select count(*) from dm_type where name not like 'dm%' select count(*) from dm_type where name like 'dm%' # User select count(*) from dm_user where user_name not like 'dm%' select count(*) from dm_user where user_name like 'dm%' # Content select sum(content_size)/(1024*1024*1024) from dmr_content