If you are sent a message that has another message as an attachment that message will be linked to that mailbox and searchable in that mailbox.
To find out if the message arrived as an attached message you will need to query the ArchiveManager database.
Find and open the message in the Archive Manager website
With the message open in Internet Explorer right click the message and select properties.
Copy the value for the Address (URL) field.
From that field copy the checksum
For example the url will look like http://archivemanager/ViewMessage.aspx?CheckSum=a23d7658-cfba-b5d5-fb71-a4e0e679871a
Copy the checksum which in the above example is a23d7658-cfba-b5d5-fb71-a4e0e679871a
Then run the following query in SQL Management Studio on the server with the Archive Manager database replacing the checksum in this line with the one from above.
Set @Checksum = 'a23d7658-cfba-b5d5-fb71-a4e0e679871a'
Then in SQL Management Studio on the server with the Archive Manager database click the New Query button and paste in your query.
/****** Script Find Parent Message******/
USE ArchiveManager
DECLARE @Checksum uniqueidentifier
Set @Checksum = 'a23d7658-cfba-b5d5-fb71-a4e0e679871a'
Select * from Message where MessageID in (
SELECT MessageID FROM Attachment where AttachedMessageID = ( SELECT MessageID FROM MESSAGE WHERE CHECKSUM = @Checksum))
/****** End Script Find Parent Message******/
This query will return results if the Checksum you used belonged to a message that was sent as an attachment.
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Support and Development.
Quest Support and Development recommend to always make a backup of the current database prior to execution of any script(s) that may modify it.
