Hey. First of all, I'm new here, so I apologize in advance if my question has already an answer. So, basically, here's the fact: the company I work in would like a report to reveal all the notes that were created regarding a ticket. I couldn't find anything like it in OTRS, so I went to another reporting tool and I ended up with this query: SELECT ticket.tn, COUNT(ticket_history.history_type_id) AS '# of Notes' FROM ticket_history LEFT JOIN ticket ON (ticket_history.ticket_id = ticket.id) WHERE ticket_history.history_type_id = 15 AND ticket_history.create_time BETWEEN startDate AND endDate GROUP BY ticket.id; It's part of a procedure, so that's why I have a startDate and an endDate. My question is if anyone of you guys know what history_type_id's are used when adding a note. Thank you very much in advance.