Nested reports

kg4ult
Tera Contributor

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??

1 ACCEPTED SOLUTION

Robert H
Mega Sage

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:

 

RobertH_1-1745648423474.png

 

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

 

RobertH_0-1745648351991.png

 

Regards,

Robert

View solution in original post

6 REPLIES 6

kg4ult
Tera Contributor

This is exactly what i needed. Thank you ill show them now.

AndersBGS
Tera Patron
Tera Patron

Hi @kg4ult ,

 

I would recommend you to reach out to your ServiceNow administrators to have this task completed. 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/