The Problem
How can we calculate the total native size of the files that were OCR'd successfully
Resolution
Select the project database in your SQL Management Studio and run the following query:
select
count(1) [OCR Document Count],
SUM(isnull(filesize,0))/(1024.0*1024)[OCR Document Native Size(MB)]
FROM
tbl_ex_FileInfo FI WITH(NOLOCK)
INNER JOIN
tbl_ocr_Shadow SH WITH(NOLOCK)
ON
fi.FileId=sh.FileId
where ProcessingFlag=2 AND ErrorType IS NULL
Comments
0 comments
Please sign in to leave a comment.