custom field in the sys_user table to find the managers, manager

[Sandeep Rajput]

@019962 Why would you like to create a custom field to find manager's manager? What is the use case here?

We already have a manager field on sys_user record, ServiceNow allows dot walk on a field, you can always dot walk to the manager field to find the manager of the manager.

Hope this helps.

[D-Frost]

I believe sys_user has the Manager's name, but not the Manager's employee number (it includes the User's employee number, but not the Manager's).  We, for example, have several managers with identical names, and it is necessary to use the manager's employee number, which is not in the sys_user table by default.  Although this can be built into a report, that does not make it part of the table (e.g. in a scenario of data export directly from a table, not a report).