Mumbai, India
ecmnotes.com parag@ecmnotes.com

Documentum Repository Pre-Cloning Queries

# Generic
select count(*) from <object_types>

# 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

Leave a Reply