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.
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.