I’m looking for the “HeldBy” field in the database. Is it somewhere linked directly to the asset or is the only way via the transactions?
The reasons I’m asking is, I want to build a sql-query that shows every asset which is held by a specific person.
(Get all assets where user “123” is in the “HeldBy” field.)
Also is there an updated RT Database Schema?
The only one I found is without RT:Assets (Schema - Request Tracker Wiki)