Overview
It may be necessary to check the file extensions of exported items in Archive Shuttle, in order to do that review the steps below.
Steps
The following SQL will show the file extensions of exported items for a particular container mapping ID:

DECLARE @mappingId int;
SET @mappingId = 2;
-- Get all items where is no file extension or is other then .msg
select I.ItemId, FE.Name FROM Item I LEFT JOIN 
    FileExtension FE ON FE.FileExtensionId = I.FileExtensionId INNER JOIN
    ItemRouting IR ON IR.ItemId = I.ItemId
WHERE IR.ContainerMappingId = @mappingId AND (I.FileExtensionId is null OR FE.Name <> '.msg');

 

Print Friendly, PDF & Email