Is there a way to reference FULL_NAME information from qcsiteadmin_db.td.users from a business view?

Question ID: 109282
2
0

Is there a way to reference FULL_NAME information from qcsiteadmin_db.td.users from a business view? We have a need to provide a person’s full name in addition to the user name that is used throughout HP ALM for BG_RESPOSIBLE, BG_DETECTED_BY, TS_RESPONSIBLE, etc. The USERS table in each project has fields for this information but these are empty, I presume because we are importing users from LDAP and using LDAP authentication for HP ALM sign-on. Hence the need to reference qcsiteadmin_db.td.users. Just need a way to establish the relationship within the business view definition.

Marked as spam
Posted by (Questions: 86, Answers: 3)
Asked on February 5, 2020 1:58 pm
12 views
Answers
2
Private answer

If you have full access to that DB (not all users accounts have that access), you should be able to gather that information through a SQL query, but you would need to do it by accessing the userID associated to the user account trying to be parsed for that information, as the projects only have the userID and username associated with them and not the full user information, as †hat is stored in the qcsiteadmin schema only and uses the userID as the key field linking the two.

Marked as spam
Posted by (Questions: 0, Answers: 327)
Answered on February 5, 2020 1:59 pm