ALM Reports — Getting the Full Name for Users
Question ID: 108152

We are trying to create some reports where we would list the user assigned to a Requirement (author) as well as who updated a Requirement. We want to have the report list the user’s full name as entered in Site Admin. If I create a project report, the project report will display the Author’s full name. How do we display the full name in an EXCEL or Business View report?

Marked as spam
Posted by (Questions: 113, Answers: 8)
Asked on February 1, 2018 12:57 am
Answers (1)
Private answer

Looking into the question that you had about how to get the full name in either a Business Views or Excel report I have the following information.

The Full Name of the user is no longer stored in the project. It is stored in the Site Admin database. Here is the information from the Project Database reference for the User table.

Since this information is not stored in the Project database you would not be able to use Business Views to display the full name in a report. The Business Views feature cannot attach to the Site Admin database and macro enabled excel files cannot be used with the Business Views feature.

If you were to use Excel Reports you would need Query the User table of the Project DB to get the username (which is still stored in the Project database) and then on the Post-processing tab use the Site Admin API (which will require that you register a copy of the Site Admin on the workstation) to get the full name associated with the user name that was retrieved in the query on the Project DB.

Here is a link to the online documentation for the API References for ALM 12.53 to included the Project DB, ALM OTA API, and the Site Admin API references.

Marked as spam
Posted by (Questions: 0, Answers: 309)
Answered on February 1, 2018 12:59 am
Since the US_FULLNAME field is not used you could populate it if you wanted. The things to keep in mind would be that you would have to maintain this information is some way (ex. Someone gets married and thier name changes) and in future versions this field may be removed.
( at February 1, 2018 1:00 am)
Thank you for the explanation and links to great Help information. Would it be a bad idea to update the US_FULLNAME on the project with the user's fullname as listed in the Site Admin database?
( at February 1, 2018 1:00 am)

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top