1. Select the Analysis tab.
  2. Click Information library.
  3. Click Add an ad-hoc query.
  4. Select Sales Order as your source view by double clicking it. 
  5. From the left hand side, expand the nodes Sales Order Item\Sales Order Item Ticket by clicking the "+" buttons next to them. 
  6. Highlight the Tickets node. 
  7. From the middle field drag Scan Date into include records where. Set the criteria to Blank via the drop down. 
  8. From the middle field, drag Ticket Number into include records where. Set the criteria to Not Blank. 
  9. From the middle field, drag Ticket Number into results fields to display. 
  10. Fromt he left hand side, highlight the Program Event's node located under the Sales Order Item Ticket node.
  11. From the middle, drag Event record into include records where. Search for the event in question.
  12. (Optional) If you want to do the program as a whole, highlight the Program node under Sales Order Item Ticket. Then drag Program record into include records where. Search for your program in question. 
  13. Click the Set save options tab to name your query.
  14. Click Save.
  15. Click Preview results to make sure you are pulling records. 
  16. (Optional) If you want your ticket numbers in a spread sheet for easy access click the Export to CSV button and Altru will export a Excel spreadsheet of the results of this query.
You can follow the steps in this article to scan tickets for program events that happened in the past