List user profile information

Ben Cohen

Hello,

I am trying to list usernames with personal information such as first name,last name,phone number etc.

I know that the first\last name is stored in cwd_user table and the phone number is in the OS_PROPERTYENTRY table. I do not know how to make the connection between those two tables.

 

Thanks,

Ben

Fabio Racobaldo _Catworkx_

Hi @Ben Cohen ,

you can retrieve all information about data model at the following page https://confluence.atlassian.com/doc/confluence-data-model-127369837.html

Hope this helps,

Fabio