How to export all the CIs under a Application Service with relationship L1 to L5?

ArulRaj
Tera Contributor

ArulRaj_1-1744273645969.png

How to get all the CIs under a specific Application Service, L1 to L5 as shown in the images, is there any table?

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @ArulRaj 

The best way is to go to the cmdb_ci_rel table, where you can download the records. However, it's not that straightforward. You can add the relationship type and the specific AS  to filter the data as needed.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @ArulRaj 

The best way is to go to the cmdb_ci_rel table, where you can download the records. However, it's not that straightforward. You can add the relationship type and the specific AS  to filter the data as needed.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi Atul,

Thanks for the solution, is there any chance of classifying the CIs as per their levels of relationships?

@ArulRaj just want to highlight, querying this relationship table will only get the first level of relationships. Not the entire hierachy 

Kieran Anson
Kilo Patron

Hi,

svc_ci_assoc holds this information as an association table, rather than querying cmdb_rel_ci for relationships