Agileuser created by / creator SQL script
I’m trying to put together some metrics via SQL statement that defines which user records were created and/or modified by whom. Agileuser table has the creation date but not any reference to the creator / created by, although the UI shows that in the history GUI. Your help is greatly appreciated! thanks in advance!
Please check item_history table. This table holds all history for “non-routable” objects. So, User would also be here
Join agileuser.id to item_history.item and class = 11605. That should give you the details you see in UI History tab