1. Navigate to Control Query
  2. Choose New > All Contacts query
  3. Expand Contacts > Interactions > Activities > Activity Name in the query editor
  4. Add the following fields as desired:
    • Activity Name is not one of Blacklisted, Unsubscribe All, Email Hard Failure, etc.
  5. Click Next
  6. Choose desired Output fields
  7. Click Next
  8. Choose your sorting preferences
  9. Finish
Please note: The maximum number of records in a results set in a query is 40,000 (see: http://www.blackbaud.com/files/support/guides/sphere/Query_Specifications.htm).