Nested reports

[kg4ult]

Hello all,

1 i am not sure what instance / version of SN i have. The stats view is blocked to me. I also cannot see the database view either also restriced.

I want to create a report to add to my dashboard where i can see the following

Parent is Application Service
child is the Application instance and its relationship type to the application service
then lastly the  "child" of the above child would be the servers associated / related to it.

Thoughts??

[Dr Atul G- LNG]

Hi @kg4ult 

Greetings!!

Try this on the list view:

cmdb_rel_ci.list

In the condition, add the required filter.

[kg4ult]

Yes i can accomplish that. I need to add to the right a second child layer (child >> grandchild) so that after you see the application instance, you can see the server names related to it on the right. Maybe click on the child and see that there is another layer beneath that reveals the (grandchild) relationship with its servers. 

[Dr Atul G- LNG]

Hi @kg4ult 

I’m not sure if we can achieve the grandchild query because for a grandchild, there is already a parent, and we are already using the parent. So, you can observe the relationship between the parent and child, and from there, you’ll need to figure out the grandchild.

[Robert H · Accepted solution]

Hello @kg4ult 

This can only be achieved by creating a Database View that joins the CI Relationship table with itself.

Please ask your ServiceNow developers to create a view like this:

Then you can create your report on that view to get results like this:

Regards,

Robert