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

[ArulRaj]

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

[Dr Atul G- LNG · Accepted solution]

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.

[ArulRaj]

Hi Atul,

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

[Kieran Anson]

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

[Kieran Anson]

Hi,

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