Schemas of Cloud Provisioning and Governance tables

Release version: Washingtondc

Updated February 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 provide a cloud-agnostic framework for managing various cloud resources. This framework allows ServiceNow customers to effectively track and manage data across different cloud providers, enabling better governance and provisioning of cloud resources.

Show full answer Show less

Key Features

Load Balancer Table: The cmdbcicloudloadbalancer table holds key attributes such as load balancer name, DNS details, and state (available or terminated).
Network Resource Table: The cmdbcinetwork table tracks network characteristics including network ID, IP address range (CIDR), default gateway, and whether the network is shared or external.
Storage Volume Resource Table: The cmdbcistoragevolume table captures details like volume ID, storage type, total capacity, and current state (available or in use).
Virtual Server Resource Table: The cmdbcivminstance table documents VM-specific information such as VM instance ID, state (on, off, or terminated), CPU count, memory size, and termination protection status.

Key Outcomes

By utilizing these tables, ServiceNow customers can efficiently manage their cloud resources, enhance visibility into their cloud environments, and ensure effective governance across multiple cloud platforms. This structured approach promotes better decision-making and resource allocation in cloud operations.

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.