email address of agile 8.5 plm users

Hello again, This question in related to Agile 8.5 PLM Oracle.

I want to extract users email address from the database, in order to do that I checked the database tables: I have userprofile and userhistory table, but both the tables does not contain email address.

I checked in page_two table too, but no luck.

I know in Agile 9.3 – we have a table called agileuser where we can extract the users information, but in agile 8.5 PLM we don’t have that table.

Could you please help me out with the information of the table regarding Agile 8.5 PLM Oracle database.


Agile User Asked on October 31, 2019 in Agile PLM (v9).
Add Comment
2 Answer(s)

User data is stored in NODETABLE, where parentid = 5005. You can get the ID and full name (description) from there. The user email will then be in PROPERTYTABLE, where PROPERTYID=46. The login of the user is then in PROPERTYTABLE where PROPERTYID=29.

Agile Angel Answered on October 31, 2019.
Add Comment

Thanks a lot Kevin, much appreciated. I got the logic now, You made my day. Your awesome.
Thanks again.

Agile User Answered on October 31, 2019.
Add Comment

Your Answer

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