04-22-2016 12:20 PM
I use the following query to get the total file size in Tarabytes:
select sum(cast([filesize] as bigint)) /1024.0/1024.0/1024.0/1024.0 from hsi.itemdatapage
The query returns 21 tatabytes.
When I look at the property of the disk drive. The usage of the disk drive for all disk groups shows that only 5 tatabytes have been used. If I modify the query by joining the table hsi.itemdata with status = 0, it would still return 21 tarabytes in total for all the items in hsi.itemdatapage.
Is there a way to get accurate file size in total for the files stored in OnBase?
04-22-2016 12:27 PM
If yu have reporting services there is a report thre tht tells you the disp space used by by each disk group.
04-22-2016 12:54 PM
If you just want the total number of bytes used by all documents in OnBase, this is the query I'd use. One limitation is if you have revisionable documents this will only look at the latest revision. Otherwise it should be quite accurate.
select sum(cast(sizes.bytes as bigint)) as 'bytes'
from
(
select distinct docdetail.itemnum as 'itemnum', sum(distinct(docdetail.pagesize)) as 'bytes'
from
(
select distinct it.itemnum as 'itemnum', ip.itempagenum as 'pagenum', ip.filesize as 'pagesize'
from hsi.itemdata it with(nolock)
inner join hsi.itemdatapage ip with(nolock) on ip.itemnum = it.itemnum
where ip.docrevnum = it.maxdocrev
) docdetail
group by docdetail.itemnum
) sizes
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.