Start the query:
  1. Navigate to Analysis, then select Information library
  2. Click Add an ad-hoc query and select Sales Orders
  3. Click OK
Add fields to Include records where:
  1. From the left column, expand Sales Order Item, then expand Sales Order Item Ticket and select Tickets. From the middle column, drag Scan Date into Include records where. Set the criteria to Blank via the drop down. 
  2. From the middle column, drag Ticket Number into Include records where. Set the criteria to Not Blank.
  3. (Optional) To see tickets for a specific event: From the left column, expand Sales Order Item, then expand Sales Order Item Ticket and select Program Event. From the middle column, drag Event record into Include records where. Search for the event in question.
  4. (Optional) To see tickets for the program as a whole: From the left column, expand Sales Order Item, then expand Sales Order Item Ticket and select Program. From the middle column, drag Program record into Include records where. Search for your program in question.
Add fields to Results fields to display:
  1. From the same middle column, drag Ticket Number into Results fields to display.
  2. (Optional) To see name of patron who purchased tickets: From the left column, select Constituents. From the middle column, drag Name into Results fields to display.


To scan tickets for program events that occurred in the past, please follow the steps in this article.