CMDB Relationship recursive reporting.

Fernando Gois · ‎01-25-2017

Hello. Has anyone built a CMDB CI relationship recursive report?

By that I mean, starting at the Business Service CI level, list the children CIs related to that Business Service. But after that, also list the lower level CIs that are "children of the children" and so forth of a recursive way. We could probably establish how many levels down the chain to report.

This report would pretty my be a representation of what we see in a Business Service dependency view, but instead of been graphical, it is a list showing all the CIs that make up the business service and their relationships.

Please, let me know.

Thanks. Fernando.

mechamberlain · ‎06-14-2017

Fernando,

I know of no way to do such a report in the Reporting Module. I'm not sure if this will help you or not, but I do have a script I threw together an example script that will do two things based on giving the script the SysID of a single "target" CI. It will "walk" the CI relationship tree downstream of the target CI and compile an array of the CI SysIDs it encounters. While doing this, it also displays the level of in hierarchy, the Name and the Class of each of the downstream CI's.

This is just to show you one way to get at the data. I'm not sure if this will help you, but I hope that it may be a starting point for you.

Attached is the script. It was 'thrown together" so it may not be pretty but it works as a proof of concept:

View solution in original post

santhoshvallabh · ‎01-25-2017

I have also the same requirement.

How Can I get relationship mapping tree results, please let me know.

We have followed the below example of product documentation for this but unfortunately got no results.

Build a Service Mapping query using the CMDB Query Builder

Thanks,

Santhosh

KCallaghan · ‎02-21-2017

I have not built such a report but, aren't the details of those relationships contained in the CMDB_REL_CI table? So if I searched for the Parent, a server, I could see all its children relationships.

Paul Coste2 · ‎07-17-2017

The main problem with the CMDB Query Builder as it exists today is that the query has to follow a specific class/relationship hierarchy. While this can be useful in some circumstances, it would be much better if there were an ability to include a sort of "fuzziness" to the query that would allow you to accept any number or type of relationships in between two nodes in the query. For example, if I want to show all Servers that depend on a Storage device, I need to define all of the various and specific ways in which the Server can depend on a Storage device. And there are many. It would be nice if I could just say "show me a list of Servers and Storage Devices with dependencies" and maybe include only certain relationship types, a min/max number of hops in the relationship path from A to B, and other filtering critiera on the intermediate relationships and CIs.

angeliccharm · ‎02-23-2017

Hi,

We've gone over your reporting requirements and found that it's a bit tough to achieve with the current query builder and reporting. Additionally, it's pretty complex to handle each scenario since business services can look vastly different. Here's a quick example we came up with: it handles a few levels from Service > Server and/or App > Other CIs. When using the CMDB Query builder, you can select new and choose "Service Mapping Query."

From there, you can build whichever relationship topology/report you want. Here's an example of what might work for what you want. Though, you can possibly go down a few more levels too. What you need to keep in mind is, queries such as these are very resource intensive if going at the CI level.

May I ask, aside from your CMDB are you doing any Service Mapping? If so, what's the current state?