Query on CMDB Relationships

Bijay Kumar Sha
Giga Guru

Hi,

I've Business Application (cmdb_ci_business_app) which is in top layer. Next I've Cloud Account (cmdb_ci_aws_account) these 2 tables are connected with ean other by Uses::UsedBy (Parent and Child table).

Next, I've EC2 Virtual Machine Instances [(cmdb_ci_ec2_instance) which extends table Virtual Machine Instance (cmdb_ci_vm_instance)] which is a downstream relationship with Cloud Account. 

But when I open any Business Application, then I can see Cloud Accounts in the downstream relationships. And similarly If I open any cloud account record, then I can see Business Application in it's Upstream relationships. 

In both the cases, I'm not seeing any record of EC2 Virtual Machine Instances in downstream. 

I would like to bring these as well on the form. How I can do that.

 

Also, I've checked in cmdb_rel_ci table, if I can fetch these EC2 VM Instance records or not. But when I search, I'm not seeing any record of these CIs.

 

Anything I'm missing here ?

1 REPLY 1

Muni Venkatesh
Tera Contributor

Hi Bijay, 

 

I have encountered with the similar issue, could you help me the relation between Cloud service Account and VM Instance table (cmdb_ci_vm_instance). Is it Uses::UsedBy (Parent and Child table) or Hosted By::Hosts or something else ?