I want to search for all contacts that have an attachment. How do I do this? I have looked under custom and advance searches. as well as searched all help documents for an answer.
That is not possible in the user interface strangely enough as far as I know :-( You can have a look in the tables if you are familiar with the database? The attachment location will be in table civicrm_file, and the link to the activity will be in table civicrm_enity_file. So getting the activities with attachments will be something like:
SELECT * FROM civicrm_entity_file WHERE entity_table='civicrm_activity'