Sql reports

RT Users
1

I would like to try to build a report to show when someone takes the
ticket the first time. how should i go about doing this?