Filter out unwanted files

Question:

We have case setting that is set to exclude all non-recognizable and all embedded images. We expected these to be excluded. When we adjust the case to Exclude all embedded files, we do not see a change in the overall documents viewable. Shouldn’t this update after making the adjustment to the case?

Resolution:

In order to find out if your file is an embedded file, first verify if the file is actually an embedded file. Venio has a field called 'Is Edoc Embeded File' which determines if a file is detected as embedded or not. If the 'Is Edoc Embeded File' field is 'NO' then the file has not been recognized as an embedded file.

However, if you want to filter out the unwanted files please follow the steps below:

1. Run the following query in search query mode. The search duplication option must be: "show all hits in the selected scope". Screenshot attached for reference. This query will retrieve all the unique email attachments that are images. Review these resulting documents and then tag the unwanted documents (e.g., with "TagA").

select FI.fileid ,FI.isparent, FI.groupid, originalgroupid, 
hashvalue,FI.custodianid, FI.mediaid from
(select FI.fileid ,FI.isparent, FI.groupid, originalgroupid ,hashvalue,FI.custodianid,
 FI.mediaid, row_number() over( partition by fi.hashvalue order by fi.fileid ) as SN
from tbl_ex_fileinfo FI, tbl_pj_FileTypesDescription FD, tbl_pj_FileTypesGroup FG
where issystem = 0 AND isdenist = 0 AND FI.IsARCHIVE=0 
and ParentDocType='EMAIL' AND fi.FileType =fd.ToolsDisplayName 
AND FG.FileTypeGroupID=FD.FileTypeGroupID AND isparent=0 and FG.FileTypeGroupID IN (30,19,13,4)
) FI where SN= 1

2. Now, search for these documents tagged with "TagA",  and export their hash values. 
3. Then perform a load file search using the exported hash values . Search duplication option must be: "show all hits in the selected scope".  The result should be the unwanted files.