You can access your site's tickets from your templates via craft.support.tickets
{% set tickets = craft.support.tickets.all() %}
{% for ticket in tickets %}
{{ ticket.id }} - {{ ticket.name }}
{% endfor %}craft.support.tickets supports the following parameters:
A User Model can be passed to get tickets for that user only.
Get tickets for that author only.
A Ticket Status Model can be passed to get tickets for that ticket status only.
Get tickets for that ticket status only.