Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Query on CMDB Relationships

Bijay Kumar Sha
Giga Guru

‎05-03-2024 03:10 AM

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 ?

0 Helpfuls
  • 392 Views
1 REPLY 1

Muni Venkatesh
Tera Contributor

‎05-24-2024 03:56 AM

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 ?

0 Helpfuls