MS CRM: Select Non-email Attachments

MSCRMSelectNonEmailAttachments.sql

  SELECT 
    DocumentBody,
    ObjectId,
    FileName,
    CONVERT(varchar(255), ObjectId) + '_' + CONVERT(varchar(255), Filename) AS SaveAsFileName
  
  FROM
    FilteredAnnotation
    
  WHERE
    IsDocument = 1 AND
    (objecttypecode = 1    or -- Account         Note Attachments
     objecttypecode = 2    or -- Contact         Note Attachments
     objecttypecode = 3    or -- Opportunity     Note Attachments
     objecttypecode = 4    or -- Lead            Note Attachments
     objecttypecode = 4212 or -- All Task        Note Attachments
     objecttypecode = 4201 or -- All Appointment Note Attachments
     objecttypecode = 4210)   -- All Phone Call  Note Attachments