Hello,
I am trying to build a table of specific attachments in our 2011 MSCRM database that are email attachments. This table will be used to export the desired attachments. I'm trying to capture filename, filesize, created on date (of the email), file type, and some information about the Contact the email was sent regarding.
Per this thread I am looking at the Attachment table https://social.microsoft.com/Forums/en-US/5efb1ae7-fda0-468e-bc36-3d0242e92edd/crm-2011-what-is-the-attachment-table-in-the-mscrm-database-storing?forum=crm
I am looking for confirmation on the other tables I need to join to get the desired attributes.
Currently I am joining:
Attachment to ActivityMimeAttachment via AttachmentID
ActivityMimeAttachment to Email via ObjectID = ActivityID
Email to Contact via RegardingObjectID = ContactId
Will this work for what I am trying to accomplish or should I be looking at the Activity Pointer tables?
Thank you!
*This post is locked for comments
I have the same question (0)
