Nested reports

Go to solution
kg4ult
Tera Contributor

‎04-25-2025 01:03 PM

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

0 Helpfuls
  • 1,967 Views
1 ACCEPTED SOLUTION

Go to solution
Robert H
Mega Sage

‎04-25-2025 11:25 PM

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

Go to solution
kg4ult
Tera Contributor
In response to Robert H

‎04-28-2025 06:54 AM

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

0 Helpfuls

Go to solution
AndersBGS
Tera Patron
Tera Patron

‎04-26-2025 09:01 AM

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/

0 Helpfuls