How to get all the servers in relationship with the application service(CI Record) .

[Naveen Kokkirap]

Hello Team,

im trying to get the servers related to application service (ci record) which has business criticality as '1-most critical' upto L3 level of relationship.

I can get these from cmdb_rel_ci table by one by one. But i need all of them. Im trying to get these by  using query builder but couldn't get the final output.

[Naveen Kokkirap]

Hello Ajay,

i have tried this but im getting upto Level 2 only by using query builder 

but in my case i need uptp L3 to L4

Any suggestions..?

[Mercedes Pons 1]

Hi Naveen, if I understand your question, what I use to do is to create a Report directly from this table Service Configuration Item Association [svc_ci_assoc] and you can filter what you want to visualize.  I hope this helps.