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

Jeff Boltz1 · ‎07-25-2017

Thanks Paul, I'm just experimenting with it in sub-prod. Has anyone seen the CMDB CI Report app discussed at K17 in this post: CMDB CI Report App

Paul Coste2 · ‎07-25-2017

Thanks Jeff. No, I hadn't seen that post and will definitely check out the presentation. Not sure how I missed that session at K17, thanks for sharing! One thing I did catch, on a "related" note, was another session on how to auto populate CI Groups meeting certain "defect" criteria on the attributes or relationships, and then run rules on the members of those groups to automatically correct the defects. Like a group of Servers where the OS field was not populated, and setting it to Windows if the name of the CI contained "WIN". It was a pretty slick approach, though could probably be done better with the newer capabilities. If anyone knows about that session or has a link to it, please send a link. Thanks!

gyedwab · ‎07-25-2017

This is something we added to Explore Analytics, to be able to do group-by or filtering based on the upstream business services, regardless of whether they're one or multiple levels up. You can also use other classes (e.g. roll up to parent Applications)

There's a video showing the solution here:

Explore Analytics - Business Service Reporting - YouTube

If this might be what you're interested in, you can sign up for a free trial here and give it a shot.