Schemas of Cloud Provisioning and Governance tables

Release version: Xanadu

Updated August 1, 2024

3 minutes to read

Summarize

Summarized using AI

Summary of Schemas of Cloud Provisioning and Governance tables

The Cloud Provisioning and Governance tables are designed to be cloud-agnostic, allowing users to manage data across various cloud providers. This includes tables for load balancers, network resources, storage volumes, and virtual server instances.

Show full answer Show less

Key Features

Load Balancer Table: [cmdbcicloudloadbalancer] includes attributes like objectid, canonicalhostedzoneid, dnsname, and state to manage load balancer configurations.
Network Resource Table: [cmdbcinetwork] tracks network details with attributes such as objectid, cidr, defaultgateway, and state, enabling effective network management.
Storage Volume Resource Table: [cmdbcistoragevolume] features attributes like objectid, volumeid, storagetype, and state to oversee storage volumes within the cloud.
Virtual Server Resource Table: [cmdbcivminstance] captures VM details including objectid, state, cpus, memory, and terminationprotection, facilitating VM lifecycle management.

Key Outcomes

Utilizing these schemas allows ServiceNow customers to efficiently provision and govern cloud resources. By understanding the key attributes of each table, customers can ensure proper management of their cloud environments, optimize resource usage, and maintain visibility into the state of their cloud components.

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.

Load balancer CMDB object model — Figure 1. Schema load balancer

Table 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.

Table 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.

Table 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.

Virtual server table object model

Table 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.