Ticket Scanned Location or User

Sarah Rauscher

We have numerous windows and sites where tickets are scanned. As we have changed to timed admission, we are no longer honoring old tickets.


We want to create a query where we can see who scanned a ticket or at least the workstation it was scanned from. Has anyone found that capability in ad-hoc queries?


Or have you found a better function to see what staff has scanned tickets? We want to be able to retrain the specific staff who are having issues, rather than just making a general staff announcement.


Thanks for any tips that work for you.

Erin Donnelly

You could ticket query and choose under "Results field to display:" the field Changed by user name.


The resulting value for that field is the last person who changed the ticket, so would be the user who scanned it.


Good luck!

Sarah Rauscher

Thanks! That worked. I had selected the field Changed by user name. However, I had started it as a Sales Order query. Therefore Changed by user name showed who had created the ticket in Sales Orders.


I also found that I can filter for all tickets sold by specific staff. I just need to filter "Changed by user name is equal to [STAFF]. This report will be helpful to ensure staff are scanning the timed entry tickets for the correct time and date. Then we can counsel specific staff, instead of making a general announcement,