Location Hierarchy Reporting

[BriTaylor]

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.

[VikMach]

Hi @BriTaylor, have you tried Interactive Analysis option available on the Incident List view?
Pull the Location.Parent on your list view and then click on column context menu. You will see "Launch Interactive Analysis". Select that option and it will open a window like snip below. Here you can do you analysis based on parent and child location.

Note : There are small square shaped colorful check boxes under the bar chart. Those can be used to filter out or show matching.

Let me know if this helped.

Regards,
Vikas K

[hollydippol]

Awesome tip, Vikas! Loved the visual example. 

[VikMach]

Thank you! Please hit the helpful button when you find it helpful.

[BriTaylor]

Vikas, would this allow to report on all locations in the hierarchy? Example: Location A is the parent of Location B which is the parent to location C. 

I want to build a report that shows all locations in Location A so it would need to pull A, B, and C.