Schemas of Cloud Provisioning and Governance tables

Release version: Yokohama

Updated January 30, 2025

3 minutes to read

Summarize

Summarized using AI

Summary of Schemas of Cloud Provisioning and Governance tables

This documentation provides an overview of key database table schemas used in ServiceNow's Cloud Provisioning and Governance module, version Yokohama. The tables are designed to be cloud-agnostic, supporting data from any cloud provider. Understanding these schemas helps customers manage and govern cloud resources such as load balancers, networks, storage volumes, and virtual server instances efficiently within ServiceNow.

Show full answer Show less

Load Balancer Table (cmdbcicloudloadbalancer)

This table extends from the base virtual machine object table and stores information about load balancers. Key attributes include:

objectid: Unique identifier, typically the load balancer name.
canonicalhostedzoneid & canonicalhostedzonename: Amazon Route 53 hosted zone details.
dnsname & fqdn: Public and fully qualified DNS names, including CNAMEs.
state: Indicates whether the load balancer is available or terminated.

Network Resource Table (cmdbcinetwork)

Extending from virtual machine objects, this table captures network resource details. Important attributes include:

objectid: Unique network ID within the cloud.
name: Network name.
cidr & netmask: IP address range and subnet mask details.
defaultgateway: Internet gateway ID for routing traffic.
isshared & isexternal: Flags for network sharing and external/internal status.
dhcpenabled: Indicates dynamic or static IP assignment.
state & terminatedon: Current state and de-provisioning timestamp.

Storage Volume Resource Table (cmdbcistoragevolume)

This table defines storage volumes and extends from the base configuration item table. Key attributes include:

objectid & volumeid: Unique identifiers for the storage volume.
volumecontainer: Specific to NetApp, linking LUNs and volumes.
sharable & sharecount: Whether volume is shared across VMs and the count of sharing VMs.
storagetype: Type of storage depending on cloud provider (e.g., AWS Block, Azure PageBlob).
size & freespace: Total and available storage capacity.
state: Indicates if volume is available or in use.

Virtual Server Resource Table (cmdbcivminstance)

Captures virtual machine instance details and extends from the VM object table. Key attributes include:

objectid & name: Unique VM instance identifier and name.
state: VM lifecycle state such as on, off, or terminated.
cpus, memory, disks, disksize, nics: Hardware resource specifications.
terminatedon: Timestamp of instance termination.
terminationprotection: Boolean to prevent accidental termination (default false).

Practical Use for ServiceNow Customers

Understanding these schemas enables customers to accurately track and manage cloud resources across providers using ServiceNow’s CMDB. The cloud-agnostic design promotes unified governance and provisioning workflows. Customers can expect consistent data structures for configuring, reporting, and automating cloud resource lifecycle management in their ServiceNow environment.

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.