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.

[emir]

We would need to see your query to help.

Have you looked at svc_ci_assoc table?

[Naveen Kokkirap]

Hello emir,

in have gone through this table too...

it is giving the data of the servers some how but CI specifc..

But here i have some hierarchy 

for ex-- A(Parent) ---> B(Child)--- L1

B(parent for servers) ---> some set of servers --- L2   by this 

i want to fetch servers from A

i kknow we can acheive it by using query builder upto above condition

but i want to fetch the data upto L4

[Dr Atul G- LNG]

Hi @Naveen Kokkirap 

Could you please provide some snippet or code to check and support you. 

[AJ-TechTrek]

Hi @Naveen Kokkirap ,

You can create a report on Query Builder for CMDB_rel_ci table or in Cmdb_rel_ci table you can apply filter based on Application Service record, Also filter can be apply like Child or parent is application service table.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/