This will give you a count of collected files.

SELECT vCollectedFile.FileName, Count(vCollectedFile.FileName) AS ‘Count’
FROM vCollectedFile vCollectedFile
GROUP BY vCollectedFile.FileName
ORDER BY vCollectedFile.FileName