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.
Comments
0 comments
Please sign in to leave a comment.