How can we display in custom reports the primary user in the nice format (Firstname + space + Lastname) shown in the Computer view?

Article Id: 170544

Status: Published

Updated On: 06-12-2017 08:47

Legacy Id: TECH248258

Products:

Management Platform (Formerly known as Notification Server)

Environment:

ITMS 7.x
ITMS 8.x

Resolution:

The Computer view does not get the primary user data from the Inv_AeX_Primary_User table but rather from the vAC_PrimaryUser view.

That view ensure the display name is used for the user, and tries to get it from different data tables.

And it can be used in reports to show the primary user display name.