You are viewing limited content. For full access, please sign in.

Question

Question

Is it possible to obtain a count in each of our repositories?

asked on March 26, 2019

Can we obtain a more granular record count.  Is it possible to obtain a count in each of our repositories?  We have a few and we need to break out how many records are contained in each repository.  It is possible to obtain that information?
 

0 0

Answer

SELECTED ANSWER
replied on March 26, 2019 Show version history

Hi Douglas,

Try making the queries in the database of repository...

/*Count Folder*/
select count(*) as Folder from toc  (nolock) where etype=0
/*Count Document*/
select count(*) as Document from toc (nolock) where etype<>0 
/*Count Document Electronic*/
select count(*) as Document from toc (nolock) where etype<>0 and not toc.edoc_storeid is null
/*Count by Type Electronic Document*/
select edoc_ext as 'Type',count(*) as Document from toc (nolock) where etype<>0 and not toc.edoc_storeid is null
group by edoc_ext
/*Count Templates*/
select count(*) as Template from propset
/*Count Volume*/
select count(*) as Volumens from vol
/*Count Document by Template*/
select toc.pset_id as 'Template ID',propset.pset_name as 'Template',count(*) as 'Document' from toc (nolock) ,propset (nolock)
where toc.pset_id=propset.pset_id
group by toc.pset_id,propset.pset_name
/*Count Document by Volume*/
select toc.vol_id as 'Volume ID',vol.vol_name as 'Volume',count(*) as 'Document' from toc (nolock) ,vol (nolock)
where toc.vol_id=vol.vol_id 
group by toc.vol_id,vol.vol_name

.....

count of Users and Groups Repository, table Trustee
count page of documents, table Doc (tocid is the key)

 

regards,
Marco.

0 0

Replies

replied on March 26, 2019

Look in the Administration Console.  Check the properties of the repository's Volume.  There is a tab for Statistics which shows how many Documents, Pages, Files and size on Disk the volume has.

0 0
replied on March 26, 2019

Thanks Craig for your response. I have forwarded this to my Customer. Not sure if she is looking for a single list for all the repositories and their statistics but I will see how she responds.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.