Get managers data from User table.

[Kush Sharma]

Guys - I have a requirement to create a report/dashboard to fetch user name with 4 levels of management.

Column names - User > Manager> Manager's manager> and so on till level 4

Pls help me with best possible solution.

Thanks

[Nayan Dhamane]

Hello @Kush Sharma ,

You could use the dot walking feature given in the column selection window in the reporting section.

[Kush Sharma]

Thanks nayan , that is helpful.

Is there any other way because we wanted to edit column names as well like Manager's manager or leader ...

[nayanawadhiya1]

Hello Kush,

You can create a Database view and change the column name in the database view and use that DB table to create a report.

Check the below link for more info:

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/use/reporting/task/c_CreatingD...

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/use/reporting/task/t_RelabelAC...

Regards,

Nayan Awadhiya

[Kush Sharma]

Let me try that ...