Manager Hierarchy

[boppana]

Hi,

I need to create a report on Incident,Problem,Request, etc from a top down perspective.   I need to provide a report by VP for all of the things that happened in their departments. For example I need to produce a report for the VP of Customer Service that shows the number of Incidents and Requests that happened in their organization over that past day/week/month/year. The VP of Customer Service may have 10 Directors who have 10 managers who have 10 employees.

Any suggestions?

Thanks,

Navya

[Goran WitchDoc]

Hi,

like everything else in ServiceNow this can be done in different ways. It kind of depends on how you configured your structure.

For example on the employee record there is a manger field. going into the manager it has a manager field etc.

lets try to set up an example.

Employee: Joe

Joes manager: Beth

Beths manager(director): Jane

Janes manager(VP): Abel

here you can do a report on for example incident. Set a condition with dotwalking.

If the report is going to be run by the VP and other VPs who also want to look deep down their organisation. Then you can use dynamic on the end like this:

But for this case, remember that they need to have the same amount of managers beneath them, or it won't work.

//Göran