1. Navigate to Control > Query
  2. Click New > All Contacts Query
  3. For the Filters Expand Communities > Special Events > Friends Asking Friends > Kintera Thon
  4. Click Choose Event > select the new event > Select Participants > Click Add

    Note: Complete this process again, but select all previous year's events instead
     
  5. Highlight this filter and click Not (This will make the filter include anyone from the new event that is also not in the previous year's events.)
  6. Click Next
  7. Expand the Contacts folder to Add your chosen Output Fields
  8. Click Finish to run the query
Note: This will not account for duplicate records if a Participant has different Contact Records for different events.

If the query times out or prompts an error message, attempt an Activities query instead via:
  1. Control>Query
  2. New>Activities Query
  3. Expand Activities
  4. Click Activity Name and click Add
  5. From the dropdown, select = and then select Registration
    • If you're using Multiple Registration, select Is One Of, click the Book icon, and select Multiple Registration and Registration, then click OK
  6. Click OK
  7. Click Event Name and click Add
  8. From the dropdown, click Equals and type your event name exactly (or click Contains and enter a few identifying words)
  9. Click OK
  10. Click Event Name and click Add
  11. From the dropdown, click Not Equals and type your event name exactly (or click Not Contains and enter a few identifying words)
  12. Click OK
  13. Click Next
  14. Select the desired fields for Output
  15. Click Next to sort fields or Finish to run the query