MS CRM: Select Email Attachments

MSCRMSelectEmailAttachments.sql

  SELECT
    EA.Body,
    EA.ActivityID,
    EA.AttachmentNumber,
    EA.FileName,
    CONVERT(varchar(255), EA.ActivityID) + '_' + CONVERT(varchar(255), EA.AttachmentNumber) + '_' + CONVERT(varchar(255), EA.Filename) AS SaveAsFileName
  
  FROM
    FilteredEmail E JOIN
    ActivityMimeAttachment EA ON E.ActivityID = EA.ActivityID
    
  WHERE
    E.regardingobjecttypecode = 1 or  -- Accounts
    E.regardingobjecttypecode = 2 or  -- Contacts
    E.regardingobjecttypecode = 3 or  -- Opportunities
    E.regardingobjecttypecode = 4     -- Leads