Report content - Name of the "Created or updated by"

J-Paul Millet
Mega Guru

Hi all

I would like to display in my reports the name of the user behind the "Created by" or the "Update by". Is there a way to get it a a report (whatever is the table) ? I do see the "+" that could give us the opportunity to go into the user table. Thanks

JPaulMillet_0-1675877454965.png

 

1 ACCEPTED SOLUTION

emir
ServiceNow Employee
ServiceNow Employee

sys_created_by is a String field and not a reference, therefore there will be no + to dotwalk it. It is an Audit field that just stores the user_id of the person who did the create/update. Afaik, there is no way to do that unless you create a view with a join on the user table.

 

If it is important to the process the Created By should be captured in Opened By and updated_by should be captured in Closed By (as it is in INC Mgmt)

View solution in original post

1 REPLY 1

emir
ServiceNow Employee
ServiceNow Employee

sys_created_by is a String field and not a reference, therefore there will be no + to dotwalk it. It is an Audit field that just stores the user_id of the person who did the create/update. Afaik, there is no way to do that unless you create a view with a join on the user table.

 

If it is important to the process the Created By should be captured in Opened By and updated_by should be captured in Closed By (as it is in INC Mgmt)