question In which table Amazon AWS VM data is populated? in CMDB forum

In which table Amazon AWS VM data is populated?

Suggy — Sun, 14 Jul 2024 19:14:37 GMT

As per this docs- https://docs.servicenow.com/bundle/washingtondc-it-operations-management/page/product/discovery/reference/cloud-disco-aws-data-collected.html

VM data is populated in cmdb_ci_vm_instance table.

Why not in below table?

cmdb_ci_ec2_instance

Re: In which table Amazon AWS VM data is populated?

David104 — Mon, 15 Jul 2024 02:41:02 GMT

That's a good question, not sure if I have an answer for that one. I don't have access to an instance that is using AWS discovery at the moment, so I can't confirm what the actual behaviour is either.

I do notice though that Azure and GCP both do not have a child class under Virtual Machine Instance - the child classes that do exist there, seem to all be related to on-prem hypervisors.

I wonder if the EC2 instance class is maybe a legacy class that the ServiceNow team has moved away from using for virtual machine instances on cloud platforms.

Re: In which table Amazon AWS VM data is populated?

Harish Bainsla — Mon, 15 Jul 2024 04:27:04 GMT

Hi @Suggy

cmdb_ci_vm_instance Table

This table is used to store data about generic virtual machine instances, regardless of the underlying cloud service provider.

cmdb_ci_ec2_instance Table

This table specifically stores data about Amazon AWS EC2 instances.

Re: In which table Amazon AWS VM data is populated?

Satishkumar B — Mon, 15 Jul 2024 04:57:18 GMT

Hi @Suggy

Amazon AWS VM data is generally populated in the `cmdb_ci_vm_instance` table for generic VM data and the `cmdb_ci_ec2_instance` table for detailed, AWS-specific EC2 instance data. The `cmdb_ci_ec2_instance` table provides more specialized information and attributes specific to AWS EC2 instances.

-----------------------------------------------------------------------------------

Please consider marking my reply as Helpful 👍 and/or Accept Solution ✔️, if applicable. Thanks!