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

book

Article ID: 170544

calendar_today

Updated On:

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.

Attachments