Venio Console: Find the number of documents that were OCR'd successfully and their total native size

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