CMDB Lite Discovery Data Management
CMDB Lite Project
ServiceNow Discovery Data Management
this is a living artifact
Authored by Allena Kendrick, ServiceNow Solutions Artifact
Table of Contents
Discovery Overview
Overall CMDB Tables
Approved CMDB Tables that will be populated by Discovery
CMDB Table: Linux Server(cmdb_ci_linux_server)
Discovery Probes/Patterns
Linux Class Relationship
Linux Class Schema
CMDB Table: VmWare (cmdb_ci_vmware_instance)
VMWare Data collected
VMWare Relationships
VMWare Schema
CMDB Table: Storage (cmdb_storage_server)
Discovery Probes/Patterns
Storage Data collected by NetApp patterns
Storage Relationships
Storage Schema
CMDB Table: Oracle(oracle_db_instance)
Discovery Probes/Patterns
Oracle Data Collection
Oracle Relationships
Oracle Schema
CMDB Table: Big F5 IP(cmdb_ci_ib_bigip)
Discovery Probes/Patterns
F5 Big-IP Data collected
F5 BiG IP Relationship
F5 BIG IP Schema
CMDB Table: MSSQL(cmdb_mssql_instance)
Discovery Probes/Patterns
MSSQL Data collection
MSSQL Relationships
MSSQL Schema
CMDB Tables: Network (Router and Switch Data)
cmdb_ci_ip_router
cmdb_ci_ip_switch
Discovery Probes/patterns
Network Data collected
IP Router Relationship
IP Router Schema(cmdb_ci_ip_router
Switch Relationship(cmdb_ci_ip_switch)
Switch schema (cmdb_ci_ip_switch)
CMDB Table: Windows(cmdb_ci_windows_server)
Windows Relationships
Windows Schema
Aperture
Rack Relationship (cmdb_ci_rack)
Power Relationships (cmdb_ci_datapower_server)
Discovery Overview
Overall CMDB Tables
This is the overall CMDB data model that discovery populates using probes and patterns. Note: Ownership data is not populated by discovery.
Probes and patterns collect the information and the sensor processes it. Both get their instructions from the ECC queue. There is a worker job on the MID Server that monitors the queue for work. The monitor checks for any entries where the Queue is output and the State is ready.
Approved CMDB Tables that will be populated by Discovery
The following are the approved CMDB tables(class) to-date by the CMDB Lite Steering Committee.
CMDB Table: Linux Server(cmdb_ci_linux_server)
Discovery Probes/Patterns
|
||
Classifier |
Probes |
Pattern |
Linux |
|
|
Linux Class Relationship
Linux Class Schema
CMDB Table: VmWare (cmdb_ci_vmware_instance)
VMWare Data collected
Label |
Table Name |
Field Name |
---|---|---|
CPUs |
cmdb_ci_vm_instance |
cpus |
Disks |
cmdb_ci_vm_instance |
disks |
Disks size |
cmdb_ci_vm_instance |
disks_size |
Memory |
cmdb_ci_vm_instance |
memory |
Network adapters |
cmdb_ci_vm_instance |
nics |
State |
cmdb_ci_vm_instance |
state |
Image path |
cmdb_ci_vmware_instance |
image_path |
Template |
cmdb_ci_vmware_instance |
template |
vCenter Reference |
cmdb_ci_vmware_instance |
vcenter_ref |
vCenter Reference UUID |
cmdb_ci_vmware_instance |
vcenter_uuid |
VMWare Relationships
VMWare Schema
CMDB Table: Storage (cmdb_storage_server)
Discovery Probes/Patterns
Storage Data collected by NetApp patterns
Table |
Fields |
---|---|
cmdb_ci_storage_server |
name |
cmdb_ci_storage_cluster |
short_description |
cmdb_ci_storage_cluster_node |
name |
cmdb_ci_storage_node_element |
cluster |
cmdb_ci_network_adapter |
name |
cmdb_serial_number |
serial_number |
cmdb_ci_ip_address |
ip_address |
cmdb_ci_disk |
name |
cmdb_ci_storage_fileshare |
path |
cmdb_ci_storage_pool |
name |
cmdb_ci_storage_volume |
name |
cmdb_ci_iscsi_export |
name |
cmdb_ci_storage_controller |
name |
cmdb_ci_fc_export |
initiator_wwpn |
cmdb_ci_fc_port |
speed |
Storage Relationships
Storage Schema
CMDB Table: Oracle(oracle_db_instance)
Discovery Probes/Patterns
Oracle Data Collection
Oracle Relationships
Oracle Schema
CMDB Table: Big F5 IP(cmdb_ci_ib_bigip)
Discovery Probes/Patterns
Classifiers |
Trigger probes |
Patterns |
---|---|---|
F5 BIG-IP Load Balancer |
|
These patterns are used for standard horizontal discovery including identifying clusters:
|
F5 HTTP |
The F5 HTTP classifier does not use a trigger probe. It triggers the F5 Load Balancer REST pattern to perform data collection via REST. |
These patterns use iRules to get information via REST. Service Mapping uses these patterns for top-down discovery:
|
F5 Big-IP Data collected
Table and field |
Description |
---|---|
F5 Big-IP [cmdb_ci_lb_bigip] |
|
Name [name] |
Details about the load balancer. View a record in this table to see the upstream and downstream relationships with the load balancer. |
Serial Number [serial_number] |
|
Operational Status [operational_status] |
|
|
|
Load Balancer Interface [cmdb_ci_lb_interface] |
|
Name [name] |
Details about each interface for the load balancer. |
MAC Address [mac_address] |
|
Operational Status [operational_status] |
|
|
|
Load Balancer Pool [cmdb_ci_lb_pool] |
|
Name [name] |
The name of the pool and the method of load balancing it enables. |
Load balancing method [load_balancing_method] |
|
|
|
Load Balancer Pool Member [cmdb_ci_lb_pool_member] |
|
Name [name] |
The name, IP address, and service port that each pool member uses. |
IP Address [ip_address] |
|
Service Port [service_port] |
|
Pool [pool] |
|
|
|
Load Balancer VLAN [cmdb_ci_lb_vlan] |
|
Name [name] |
The name of the VLAN and the tag that is associated with this VLAN to identify it. |
Tag [tag] |
|
MAC Address [mac_address] |
|
|
|
Load Balancer Services [cmdb_ci_lb_service] |
|
Name [name] |
Details about the load balancer service that distributes the workload to other servers, such as web servers. |
IP Address [ip_address] |
|
Port [port] |
|
Operational Status [operational_status] |
|
Hit count [hit_count] |
|
|
|
DNS [cmdb_ci_dns_name] |
|
Name [name] |
The name and IP address of the Domain Name Server for the network adapters. |
IP Address [ip_address] |
|
|
|
Network Adapter [cmdb_ci_network_adapter] |
|
Name [name] |
Details about the network adapters on the load balancer. |
IP Address [ip_address] |
|
Netmask [netmask] |
|
Mac address [mac_address] |
|
|
|
Cluster [cmdb_ci_cluster] |
|
Name [name] |
Details about the load balancer cluster. |
Cluster status [cluster_status] |
|
Cluster ID [cluster_id] |
|
IP address [ip_address)] |
|
|
|
Cluster Node [cmdb_ci_cluster_node] |
|
Name [name] |
Details about each node in a cluster. |
Cluster ID [cluster_id] |
|
Cluster status [cluster_status] |
|
F5 BiG IP Relationship
F5 BIG IP Schema
CMDB Table: MSSQL(cmdb_mssql_instance)
Discovery Probes/Patterns
Classifier |
Trigger probes |
Pattern |
---|---|---|
Microsoft SQL Server |
|
MSSql DB On Windows Pattern |
MSSQL Data collection
Label |
Field name |
---|---|
Name |
name |
Instance |
instance_name |
TCP port |
tcp_port |
Portdynamic |
port_dynamic |
Version name |
version_name |
Edition |
edition |
Version |
version |
Engine edition |
engine_edition |
Install directory* |
install_directory |
CPU sockets* |
cpu_sockets |
Service Pack* |
service_pack |
MSSQL Relationships
MSSQL Schema
CMDB Tables: Network (Router and Switch Data)
cmdb_ci_ip_router
cmdb_ci_ip_switch
Discovery Probes/patterns
classifiers |
Trigger probes |
Patterns |
---|---|---|
Standard Network Router |
|
Network Router |
Network Data collected
Label |
Table name |
Field name |
Source |
---|---|---|---|
Serial number |
cmdb_ci |
serial_number |
SNMP, various MIBs |
Start date (only when target is a host) |
cmdb_ci |
start_date |
SNMP, RFC1213 MIB |
Manufacturer |
cmdb_ci |
manufacturer |
SNMP, RFC1213 MIB |
Model ID |
cmdb_ci |
model_id |
SNMP, RFC1213 MIB |
IP address |
cmdb_ci_network_adapter |
ip_address |
SNMP, IP MIB |
MAC address |
cmdb_ci_network_adapter |
mac_address |
SNMP, IF MIB |
Can route IP |
cmdb_ci_netgear |
can_route |
SNMP, IP MIB, BGP MIB |
Can switch IP |
cmdb_ci_netgear |
can_switch |
SNMP, dot1dBridge MIB |
Can partition VLANs |
cmdb_ci_netgear |
cdscy_router_interface |
SNMP, dot1dBridge MIB |
Can hub |
cmdb_ci_netgear |
can_hub |
SNMP, IP MIB |
Neighbor Address |
discovery_device_neighbors |
neighbor_address |
ciscoCdpMIB, lldpMIB |
Neighbor ID |
discovery_device_neighbors |
neighbor_id |
ciscoCdpMIB, lldpMIB |
Neighbor Interface |
discovery_device_neighbors |
neighbor_interface |
ciscoCdpMIB, lldpMIB |
Neighbor Source |
discovery_device_neighbors |
neighbor_source |
ciscoCdpMIB, lldpMIB |
Origin Interface |
discovery_device_neighbors |
origin_interface |
ciscoCdpMIB, lldpMIB |
IP Address |
discovery_net_arp_table |
ip_address |
SNMP, IP MIB |
MAC Address |
discovery_net_arp_table |
mac_address |
SNMP, IP MIB |
Name |
dscy_router_interface |
name |
SNMP, IP MIB |
Type |
dscy_router_interface |
type |
SNMP, IP MIB |
Number |
dscy_router_interface |
number |
SNMP, IP MIB |
IP address |
dscy_router_interface |
ip_address |
SNMP, IP MIB |
MAC address |
dscy_router_interface |
mac_address |
SNMP, IP MIB |
Destination network |
dscy_route_interface |
dest_ip_network |
SNMP, IP MIB |
Type |
dscy_route_interface |
type |
SNMP, IP MIB |
Destination network |
dscy_route_next_hop |
dest_ip_network |
SNMP, IP MIB |
Type |
dscy_route_next_hop |
type |
SNMP, IP MIB |
Next hop |
dscy_route_next_hop |
next_hop_ip_address |
SNMP, IP MIB |
Interface Index |
discovery_switch_bridge_port_table |
interface_index |
SNMP, dot1dBridge MIB |
Port |
discovery_switch_bridge_port_table |
port |
SNMP, dot1dBridge MIB |
MAC Address |
discovery_switch_fwd_table |
mac_address |
SNMP, dot1dBridge MIB |
Port |
discovery_switch_fwd_table |
port |
SNMP, dot1dBridge MIB |
Status |
discovery_switch_fwd_table |
status |
SNMP, dot1dBridge MIB |
VLAN Id |
discovery_switch_fwd_table |
vlan_id |
SNMP, dot1dBridge MIB |
Designatged Bridge MAC |
discovery_switch_spanning_tree_table |
designated_bridge_mac |
SNMP, dot1dBridge MIB |
Designated Root |
discovery_switch_spanning_tree_table |
designated_root |
SNMP, dot1dBridge MIB |
Port |
discovery_switch_spanning_tree_table |
port |
SNMP, dot1dBridge MIB |
Port Enable |
discovery_switch_spanning_tree_table |
port_enable |
SNMP, dot1dBridge MIB |
Port State |
discovery_switch_spanning_tree_table |
port_state |
SNMP, dot1dBridge MIB |
Base IP address |
dscy_swtch_partition |
base_ip_address |
SNMP, dot1dBridge MIB |
Base MAC address |
dscy_swtch_partition |
base_mac_address |
SNMP, dot1dBridge MIB |
Base netmask |
dscy_swtch_partition |
base_netmask |
SNMP, dot1dBridge MIB |
Type |
dscy_swtch_partition |
type |
SNMP, dot1dBridge MIB |
Transparent |
dscy_swtch_partition |
transparent |
SNMP, dot1dBridge MIB |
Sourceroute |
dscy_swtch_partition |
sourceroute |
SNMP, dot1dBridge MIB |
Name |
dscy_swtch_partition |
name |
SNMP, dot1dBridge MIB |
Status |
dscy_swtch_partition |
status |
SNMP, dot1dBridge MIB |
Interface number |
dscy_swtch_partition |
interface_number |
SNMP, dot1dBridge MIB |
Type |
dscy_switchport |
type |
SNMP, dot1dBridge MIB |
Status |
dscy_switchport |
status |
SNMP, dot1dBridge MIB |
MAC address |
dscy_switchport |
mac_address |
SNMP, dot1dBridge MIB |
Port number |
dscy_switchport |
port_number |
SNMP, dot1dBridge MIB |
Interface name |
dscy_switchport |
interface_name |
SNMP, dot1dBridge MIB |
Interface number |
dscy_switchport |
interface_number |
SNMP, dot1dBridge MIB |
MAC address |
dscy_swtch_fwd_rule |
mac_address |
SNMP, dot1dBridge MIB |
MAC manufacturer |
dscy_swtch_fwd_rule |
mac_mfr |
SNMP, dot1dBridge MIB |
Status |
dscy_swtch_fwd_rule |
status |
SNMP, dot1dBridge MIB |
IP address |
dscy_swtch_fwd_rule |
ip_address |
SNMP, dot1dBridge MIB |
Netmask |
dscy_swtch_fwd_rule |
netmask |
SNMP, dot1dBridge MIB |
Name |
cmdb_ci_ip_switch |
name |
|
Model ID |
cmdb_ci_ip_switch |
model_id |
SNMP, RFC1213 MIB |
Manufacturer |
cmdb_ci_ip_switch |
manufacturer |
SNMP, RFC1213 MIB |
Serial Number |
cmdb_ci_ip_switch |
serial_number |
SNMP, various MIBs |
IP address |
cmdb_ci_ip_switch |
ip_address |
SNMP, IP MIB |
Description |
cmdb_ci_ip_switch |
short_description |
|
Can route IP |
cmdb_ci_ip_switch |
can_route |
SNMP, IP MIB, BGP MIB |
Ports |
cmdb_ci_ip_switch |
ports |
SNMP, dot1dBridge MIB |
Can switch IP |
cmdb_ci_ip_switch |
can_switch |
SNMP, dot1dBridge MIB |
Can partition VLANs |
cmdb_ci_ip_switch |
can_partionvlans |
SNMP, dot1dBridge MIB |
Name |
cmdb_ci_ip_router |
name |
|
Model ID |
cmdb_ci_ip_router |
model_id |
SNMP, RFC1213 MIB |
Manufacturer |
cmdb_ci_ip_router |
manufacturer |
SNMP, RFC1213 MIB |
Serial Number |
cmdb_ci_ip_router |
serial_number |
SNMP, various MIBs |
IP address |
cmdb_ci_ip_router |
ip_address |
SNMP, IP MIB |
Description |
cmdb_ci_ip_router |
short_description |
|
Can route IP |
cmdb_ci_ip_router |
can_route |
SNMP, IP MIB, BGP MIB |
Can switch IP |
cmdb_ci_ip_router |
can_switch |
SNMP, dot1dBridge MIB |
|
IP Router Relationship |
|
|
IP Router Schema(cmdb_ci_ip_router
Switch Relationship(cmdb_ci_ip_switch)
Switch schema (cmdb_ci_ip_switch)
CMDB Table: Windows(cmdb_ci_windows_server)
Data collections will be pulled using SCCM discovery integrations. A data transform will be created to capture the information in the correct data attributes. This include host/domain names.
Windows Relationships
Windows Schema
Aperture
Aperture database currently contains data center device details. As part of this project, we will be importing the data into the appropriate table noted above. Two additional classes for RACK and Power will be utilized. The RACK and Power data cannot be scanned by discovery.
Rack Relationship (cmdb_ci_rack)
Power Relationships (cmdb_ci_datapower_server)