Location Hierarchy Reporting

BriTaylor
Kilo Sage

Hi all,

 

As a part of my current project to rebrand all of our locations within our instance we also decided to implement a location hierarchy to assist with location tracking and organization within our system.

 

One thing I cannot seem to figure out is how to run a report for all incidents coming from a particular parent. I know we can dot walk using location.parent but that would only get us up a single level.

 

So that brings me to my question, is there a way within ServiceNow's reporting tool to report on all incidents coming from a particular location and have it include any and all child locations without needing to add or conditions for each location parent? We don't want to use or statements because some of our locations may contain hundreds of child locations.

 

Example: Location A is the parent of Location B, which is also the parent of Location C, which may be a parent of location D. I need a report that pulls incidents for all four locations, preferably without needing to add or statements for each location.

8 REPLIES 8

Interactive Analysis is bit tricky.
You could create a Pivot Table from Reports itself.
I have created one for example. See snip attached below. I have highlighted for San Diego as example. It shows the parent child relationship.

 

VikMach_1-1747784144558.png


Let me know if this helped!

Regards,
Vikas K



Bert_c1
Kilo Patron

Based on your example, seems you want the location hierarchy of a particular location. A Dynamic Filter for a particular parent location can work (with a corresponding script include to get the location hierarchy) . A dynamic filter defined for filtering on a reference field to cmn_location. (I can post an example if you like.) But I don't see how you can get the hierarchy of a location without specifying a particular location.

 

Maybe the approach described above will work for you.

This is what we are thinking as well. We will need to create multiple dynamic filters for the commonly used parent locations; all others can use the text filtering based on the Full Name field.

My PDI is unavaialble, I have no Idea when I'll get one due the the maintenance problems But I'm attaching an update set I made to save my work, it has two examples. on on Group hierarchy, and one on Location hierarchy.