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 _Herzum_]

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