1. From Analysis, Click Information Library
  2. Click Add an Ad-hoc query and choose the source view of Constituent
  3. On the left expand Sales Order, click Sales Order Item. From the middle drag Type to Include records where and is on of Ticket, Membership. Mark the box to Only return records that match ALL selected values
User-added image
  1. To filter on tickets to a particular program or event (Optional)
    1. To filter on a specific program: On the left expand Sales Order, Expand Sales Order Item, Expand Sales Order Item Ticket, Click Program. From the middle drag Program Record to Include records where and set equal to your program
    2. To filter on a specific program event: On the left expand Sales Order, Expand Sales Order Item, Expand Sales Order Item Ticket, Click Program Events. From the middle drag Event Record to Include records where equal to your program event
  2. Add any fields you would like to see about these constituent to Results fields to display or use this query in an appeal mailing to mail these purchasers: How to Run an Appeal Mailing.