Schemas of Cloud Provisioning and Governance tables

The tables are cloud-agnostic and can therefore hold data for any cloud provider.

Load balancer table

The load balancer table [cmdb_ci_cloud_load_balancer] extends from [cmdb_ci_vm_object], which extends from [cmdb_ci]. Click to enlarge the image.

図 : 1. Schema load balancer

表 : 1. Key native attributes of the cmdb_ci_cloud_load_balancer table

Attribute	Description
object_id	Identifier that typically holds the load balancer name as the value.
canonical_hosted_zone_id	ID of the Amazon Route 53 hosted zone for the load balancer.
canonical_hosted_zone_name	DNS name of the load balancer.
dns_name	Public DNS name of the load balancer.
fqdn	DNS name as fully qualified domain name. Can also be a CNAME record pointed to the DNS name.
state	State of the load balancer: available or terminated.

Network resource table

The network resource table [cmdb_ci_network] extends from [cmdb_ci_vcenter_object], which extends from [cmdb_ci_vm_object], which extends from [cmdb_ci]. Click to enlarge the image.

図 : 2. Network table object model

表 : 2. Key native attributes of the cmdb_ci_network table

Attribute	Description
object_id	Identifier that typically holds the network ID as the value. Uniquely identifies an object within a cloud.
name	Name of the network.
cidr	IP Address range. Classless inter-domain routing is a set of internet protocol standards that is used to create unique identifiers for networks.
default_gateway	Holds InternetGatewayID if we attach IntenetGateway to the network. A default gateway serves as an access point or IP router that a networked computer uses to send information to a computer in another network or Internet. The specified gateway is used by default unless an application specifies a different gateway.
Broadcast_address	IP address used to transmit messages and data packets to network systems.
Is_shared	Boolean. true: Network shared across other projects. false: Network not shared across other projects.
max_ports	Maximum number of hosts that can be connected to the network
is_external	Boolean. true: Network is external. false: Network is internal.
terminated_on	Time that the network was de-provisioned.
state	State of the network: available or terminated.
netmask	Type of CIDR. 32-bit mask that divides an IP address into subnets and specify the hosts that are available on the network.
dhcp_enabled	Boolean: true: Dynamic IP address is assigned to host false: Static IP address is assigned to host

Storage volume resource table

The storage volume resource table [cmdb_ci_storage_volume] extends from [cmdb_ci]. Click to enlarge the image.

図 : 3. Schema storage volume

表 : 3. Key native attributes of the cmdb_ci_storage_volume table

Attribute	Description
object_id	Identifier that typically holds the object ID as the value. Uniquely identifies an object within a cloud.
volume_id	Identifier that typically holds the volume ID as the value. Uniquely identifies an object within a cloud.
volume_container	For NetApp only, LUN becomes the volume and NetApp volume becomes the volume container.
sharable	Boolean. true: Volume is shared by multiple VMs. false: Volume is not shared by multiple VMs.
storage_type	Type of storage. AWS: Block Azure: PageBlob vSphere: VMware vdisk
size	Total capacity of the volume.
free_space	Available space of the volume
state	State of the volume: available or in_use.
share_count	Number of VMs that are shared by the volume.

Virtual server resource table

The virtual server resource table [cmdb_ci_vm_instance] extends from [cmdb_ci_vm_object], which extends from [cmdb_ci]. Click to enlarge the image.

表 : 4. Key native attributes of the cmdb_ci_vm_instance table

Attribute	Description
object_id	Identifier that typically usually holds the VM instance ID. Uniquely identifies an object within a cloud.
name	Name of the VM.
state	State of the VML: on, off, or terminated.
cpus	Number of CPUs.
memory	Memory size in megabytes.
disks	Number of disk drives.
disk_size	Total size of disks in gigabytes.
nics	Number of network interface adapters.
terminated_on	Time that the instance was terminated.
termination_protection	Boolean. Default value is false. true: Can prevent the instance from being accidentally terminated using Amazon EC2. false: Cannot prevent the instance from being accidentally terminated using Amazon EC2.