Reference record with sys_id but no display value

[sruthi1]

Hello,

I have a functionality where servers are imported into the system through import set. When server data is imported software installation records are automatically created. In this scenario there are some records with empty display value for "installed on"(reference: server) but contains sys id.

In this screenshot the installed on value is shown empty but when I group by installed on we can see there is sys id for that field.

Kindly help with this issue.

Thanks,

Sruthi

[Oliver Stammler · Accepted solution]

Hey again @sruthi1,
allright, then this is the solution to your initial question of why the display value is empty.
It is empty because the reference is invalid and it can't find a record to display.

The reason why these these records are missing could be your import error. 
You should further investigate them.

Best regards

Oli