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?
Question
Question
Is it possible to obtain a count in each of our repositories?
asked on March 26, 2019
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