Show the Name of the sys_updated_by field user in a report

[Dan Brown2]

Hi,

Is it possible to show the Name of the sys_updated_by field user in a report?

Thank you,

Dan 

[Allen Andreas]

Hi,

If you select the "Updated by" field, that will show you their name.

For example:

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi,

I thought at first you said opened_by, but you're talking about the updated_by.

Unfortunately, that shows you just their userid, there isn't a way outside of using the sys_user table to show their name. You aren't able to dot-walk to that field as it's not a reference field and merely a string.

You could consider creating a reference field that the updated by can use as well, but out of box, there isn't anything that would show you the name.

Example: https://community.servicenow.com/community?id=community_question&sys_id=d21c8f25db9cdbc01dcaf3231f96...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Onkar Pandav]

Hi,

The field 'sys_updated_by' is not a reference to the client table, and don't contain a sys_id.

It's a simple string, probably for performance reason. But it's a very low level field for the platform. If you modify its behavior, you may suffer from unexpected side-effects later on.

You can write below code in default value tab of that field:

javascript:gs.getUser().getDisplayName();

[Allen Andreas]

Hello,

Thank you for visiting the link I provided above and then quoting from Shiva's post within that thread that says:

"The field 'sys_updated_by' not a reference to the client table, and don't contain a sys_id. It's a simple string, probably for performance reason. But it's a very low level field for the platform. If you modify its behavior, you may suffer from unexpected side-effects later on."