I want to get the following details (User ID, full name of the user and email address) of the user. Can some one help me from which DBC table / View I can find these details of the user? Thanks!
You can get user information’s from dbc.users or dbc.UsersV; I'm not sure about the column for email address; Sometimes you can get it in "CommentString" column of these table/views.
Hope this helps!