Agileuser created by / creator SQL script

Answered

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!

Agile User Asked on January 8, 2023 in Agile PLM (v9).
Add Comment
2 Answer(s)
Best answer

Hello

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

Thanks

Raj

Agile Angel Answered on January 21, 2023.
Add Comment

Perfect, you’re awesome! Thank you so much, Raj, your answer is greatly appreciated!

Agile User Answered on January 25, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.