Venio Console: How do I get the working file size?

Problem

I want to get the working file size of a media and/or a project

Recommended Resolution

You can check the report in Venio Console > Report > User Reports > Ingestion/Processing Reports > Ingestion Reports on expanded files > Expanded File Size Report.

Backend Resolution

The following query will get the woking size for a media. This includes duplicates and excludes archives, systems, and de-nist.

SELECT 
[tbl_ex_Media].[MediaName], SUM([tbl_ex_FileInfo].FileSize) AS TotalFileSizeBytes 
FROM 
[tbl_ex_FileInfo] 
LEFT JOIN [tbl_ex_Media] ON [tbl_ex_FileInfo].MediaID = [tbl_ex_Media].MediaID 
WHERE 
 [tbl_ex_fileinfo].IsSystem=0 AND
 [tbl_ex_fileinfo].IsDenist=0 AND
 [tbl_ex_fileinfo].IsArchive=0 AND
 [tbl_ex_Media].[MediaName] = '<your media name>' --replace with your media name
GROUP BY 
      [tbl_ex_Media].[MediaName]

If you need to exclude duplicate please add  [tbl_ex_fileinfo].IsDuplicate=0 in the query filter.

Entire Project

The following query will get the woking size for a project. This includes duplicates and excludes archives, systems, and de-nist.

SELECT 
SUM([tbl_ex_FileInfo].FileSize) AS TotalFileSizeBytes 
FROM 
[tbl_ex_FileInfo] 
WHERE 
 [tbl_ex_fileinfo].IsSystem=0 AND
 [tbl_ex_fileinfo].IsDenist=0 AND
 [tbl_ex_fileinfo].IsArchive=0 

If you need to exclude duplicate please add  [tbl_ex_fileinfo].IsDuplicate=0 in the query filter.