CMDB classes targeted in Service Graph Connector for SolarWinds
Summarize
Summary of CMDB classes targeted in Service Graph Connector for SolarWinds
The Service Graph Connector for SolarWinds integrates SolarWinds data into ServiceNow's Configuration Management Database (CMDB). It periodically pulls detailed configuration item (CI) data from SolarWinds and populates various CMDB tables, which extend from the baseConfiguration item [cmdbci]table. This enables customers to maintain an accurate and comprehensive CMDB reflecting their IT infrastructure and cloud environments as discovered by SolarWinds.
Show less
Key Features
- Data Population in CMDB Classes: The connector populates attributes in multiple CMDB classes such as IP Address, Software Instance, Availability Zone, Cloud Key Pair, Cloud Service Account, Cloud Subnet, Hardware Type, Computer, MS SQL Database, MSFT SQL Instance, Disk, Hardware, IIS Virtual Directory, Logical Datacenter, Microsoft IIS Web Server, Cloud Network, Network Adapter, OS Template, SAM SW Install, Serial Number, Software, Storage Volume, and VM Instance.
- Attribute Updates: Each CI class receives specific attributes from SolarWinds data, such as IP addresses, CPU details, installation dates, serial numbers, operational statuses, and relationships to other CIs.
- Relationships Between CIs: The connector establishes meaningful relationships between CIs, such as "Hosted on," "Contains," "Runs on," "Reference," "Virtualized by," and "Provisioned from." For example, a Computer CI can be virtualized by a VM Instance CI, and a Disk CI is contained by a Computer CI.
- Cloud and Virtualization Support: The integration covers cloud-specific entities like Logical Datacenter, Availability Zone, Cloud Network, Cloud Subnet, and VM Instances, supporting hybrid and cloud infrastructure visibility.
Practical Benefits for ServiceNow Customers
- Comprehensive Infrastructure Visibility: Customers gain a detailed and continuously updated CMDB that reflects their physical, virtual, and cloud assets, improving IT service management accuracy.
- Improved Relationship Mapping: Clear CI relationships facilitate impact analysis, root cause identification, and change management by showing how components interconnect.
- Support for Software and Hardware Management: With software instances, SQL databases, and hardware details imported, customers can better manage software licenses, compliance, and hardware lifecycle.
- Cloud Resource Tracking: Attributes and relationships related to cloud resources help customers manage cloud deployments and hybrid environments effectively.
Implementation Considerations
To utilize these capabilities, customers must complete the Service Graph Connector setup and configure periodic data pulls from SolarWinds. The populated CMDB tables and relationships enable enhanced configuration management and align with ServiceNow’s ITOM best practices.
When you complete setting up the connection, you can configure the integration to periodically pull data from SolarWinds. The data is saved in tables that extend from the Configuration item [cmdb_ci] table.
| Attribute label | Attribute name |
|---|---|
| IP Address | ip_address |
| Netmask | netmask |
| IP version | ip_version |
| Nic | nic |
| Parent class | Relationship type | Child class |
|---|---|---|
| IP Address [cmdb_ci_ip_address] | Reference | Network Adapter [cmdb_ci_network_adapter] |
| Attribute label | Attribute name |
|---|---|
| Install date | install_date |
| Installed on | installed_on |
| Name | name |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software Instance [cmdb_software_instance] | Reference | Computer [cmdb_ci_computer] |
| Software Instance [cmdb_software_instance] | Reference | Hardware [cmdb_ci_hardware] |
Availability Zone [cmdb_ci_availability_zone]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| Parent class | Relationship type | Child class |
|---|---|---|
| Availability Zone [cmdb_ci_availability_zone] | Contains::Contained by | Cloud Subnet [cmdb_ci_cloud_subnet] |
| Availability Zone [cmdb_ci_availability_zone] | Contains::Contained by | Cloud Network [cmdb_ci_network] |
Cloud Key Pair [cmdb_ci_cloud_key_pair]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Cloud Key Pair [cmdb_ci_cloud_key_pair] | Hosted on::Hosts | Logical Datacenter [cmdb_ci_logical_datacenter] |
Cloud Service Account [cmdb_ci_cloud_service_account]
| Attribute label | Attribute name |
|---|---|
| Account Id | account_id |
| Datacenter Type | datacenter_type |
| Name | name |
| Object ID | object_id |
Cloud Subnet [cmdb_ci_cloud_subnet]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| source_recency_timestamp |
Compute Template [cmdb_ci_compute_template]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Hardware Type [cmdb_ci_compute_template] | Hosed on::Hosts | Logical Datacenter [cmdb_ci_logical_datacenter] |
Computer [cmdb_ci_computer]
| Attribute label | Attribute name |
|---|---|
| CPU core count | cpu_core_count |
| CPU core thread | cpu_core_thread |
| CPU manufacturer | cpu_manufacturer |
| CPU name | cpu_name |
| CPU speed (MHz) | cpu_speed |
| source_recency_timestamp | |
| Is Virtual | virtual |
| Parent class | Relationship type | Child class |
|---|---|---|
| Computer [cmdb_ci_computer] | Virtualized by::Virtualizes | Virtual Machine Instance [cmdb_ci_vm_instance] |
| Computer [cmdb_ci_computer] | Contains::Contained by | Disk [cmdb_ci_disk] |
DB Mssql Database [cmdb_ci_db_mssql_database]
| Attribute label | Attribute name |
|---|---|
| Data Base | database |
| Name | name |
| Parent class | Relationship type | Child class |
|---|---|---|
| MS SQL DataBase [cmdb_ci_db_mssql_database] | Runs on::Runs | Hardware [cmdb_ci_hardware] |
DB Mssql Instance [cmdb_ci_db_mssql_instance]
| Attribute label | Attribute name |
|---|---|
| Edition | edition |
| Install Status | install_status |
| Instance Name | instance_name |
| Name | name |
| Operational status | operational_status |
| Service pack | service_pack |
| Parent class | Relationship type | Child class |
|---|---|---|
| MSFT SQL Instance [cmdb_ci_db_mssql_instance] | Runs on::Runs | Hardware [cmdb_ci_hardware] |
| MSFT SQL Instance [cmdb_ci_db_mssql_instance] | Contains::Contained by | MS SQL DataBase [cmdb_ci_db_mssql_database] |
Disk [cmdb_ci_disk]
| Attribute label | Attribute name |
|---|---|
| Device ID | device_id |
| Disk space (GB) | disk_space |
| Free disk space (GB) | free_space |
| Manufacturer | manufacturer |
| Model ID | model_id |
| Name | name |
| Size | size |
| Size bytes | size_bytes |
| source_recency_timestamp | |
| Volume serial number | volume_serial_number |
| Parent class | Relationship type | Child class |
|---|---|---|
| Disk [cmdb_ci_disk] | Reference | Computer [cmdb_ci_computer] |
Hardware [cmdb_ci_hardware]
| Attribute label | Attribute name |
|---|---|
| cpu_count | |
| Default Gateway | default_gateway |
| DNS Domain | dns_domain |
| Fully qualified domain name | fqdn |
| Manufacturer | manufacturer |
| Model ID | model_id |
| Name | name |
| os | |
| os_service_pack | |
| os_version | |
| ram | |
| Serial number | serial_number |
| source_recency_timestamp | |
| Class | sys_class_name |
| Parent class | Relationship type | Child class |
|---|---|---|
| Hardware [cmdb_ci_hardware] | Owns::Owned by | IP Address [cmdb_ci_ip_address] |
| Hardware [cmdb_ci_hardware] | Owns::Owned by | Network Adapter [cmdb_ci_network_adapter] |
IIS Virtual directory [cmdb_ci_iisdirectory]
| Attribute label | Attribute name |
|---|---|
| Alias | alias |
| Installation directory | install_directory |
| Name | name |
| Parent class | Relationship type | Child class |
|---|---|---|
| IIS Virtual Directory [cmdb_ci_iisdirectory] | Runs on::Runs | Hardware [cmdb_ci_hardware] |
IP Address [cmdb_ci_ip_address]
| Attribute label | Attribute name |
|---|---|
| IP Address | ip_address |
| IP version | ip_version |
| Netmask | netmask |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| IP Address [cmdb_ci_ip_address] | Reference | Network Adapter [cmdb_ci_network_adapter] |
Logical Datacenter [cmdb_ci_logical_datacenter]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Region | region |
| source_recency_timestamp | |
| Class | sys_class_name |
| Parent class | Relationship type | Child class |
|---|---|---|
| Logical Datacenter [cmdb_ci_logical_datacenter] | Contains::Contained by | Availability Zone [cmdb_ci_availability_zone] |
| Logical Datacenter [cmdb_ci_logical_datacenter] | Hosted on::Hosts | Cloud Service Account [cmdb_ci_cloud_service_account] |
Microsoft IIS Web Server [cmdb_ci_microsoft_iis_web_server]
| Attribute label | Attribute name |
|---|---|
| Install Status | install_status |
| Name | name |
| Operational status | operational_status |
| PID | pid |
| Running process command | running_process_command |
| Type | type |
| Version | version |
| Parent class | Relationship type | Child class |
|---|---|---|
| Microsoft iis Web Server [cmdb_ci_microsoft_iis_web_server] | Contains::Contained by | IIS Virtual Directory [cmdb_ci_iisdirectory] |
| Microsoft iis Web Server [cmdb_ci_microsoft_iis_web_server] | Runs on::Runs | Hardware [cmdb_ci_hardware] |
Network [cmdb_ci_network]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Cloud Network [cmdb_ci_network] | Contains::Contained by | Cloud Subnet [cmdb_ci_cloud_subnet] |
| Cloud Network [cmdb_ci_network] | Hosted on::Hosts | Logical Datacenter [cmdb_ci_logical_datacenter] |
Network Adapter [cmdb_ci_network_adapter]
| Attribute label | Attribute name |
|---|---|
| DHCP Enabled | dhcp_enabled |
| MAC Address | mac_address |
| Mac manufacturer | mac_manufacturer |
| Name | name |
| Netmask | netmask |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Network Adapter [cmdb_ci_network_adapter] | Reference | Hardware [cmdb_ci_hardware] |
OS Template [cmdb_ci_os_template]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Image [cmdb_ci_os_template] | Hosted on::Hosts | Logical Datacenter [cmdb_ci_logical_datacenter] |
SAM SW Install [cmdb_sam_sw_install]
| Attribute label | Attribute name |
|---|---|
| discovery_source | |
| display_name | |
| last_scanned | |
| publisher | |
| source_recency_timestamp | |
| version |
Serial Number [cmdb_serial_number]
| Attribute label | Attribute name |
|---|---|
| Serial Number | serial_number |
| Serial Number Type | serial_number_type |
| source_recency_timestamp | |
| Valid | valid |
| Parent class | Relationship type | Child class |
|---|---|---|
| Serial Number [cmdb_serial_number] | Reference | Hardware [cmdb_ci_hardware] |
Software Instance [cmdb_software_instance]
| Attribute label | Attribute name |
|---|---|
| Install date | install_date |
| Name | name |
| source_recency_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software Instance [cmdb_software_instance] | Reference | Computer [cmdb_ci_computer] |
| Software Instance [cmdb_software_instance] | Reference | Hardware [cmdb_ci_hardware] |
Spkg [cmdb_ci_spkg]
| Attribute label | Attribute name |
|---|---|
| Key | key |
| Manufacturer | manufacturer |
| Name | name |
| source_recency_timestamp | |
| Version | version |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software [cmdb_ci_spkg] | Reference | Software Instance [cmdb_software_instance] |
Storage Volume [cmdb_ci_storage_volume]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Object ID | object_id |
| Size bytes | size_bytes |
| Volume ID | volume_id |
| Parent class | Relationship type | Child class |
|---|---|---|
| Storage Volume [cmdb_ci_storage_volume] | Hosted on::Hosts | Logical Datacenter [cmdb_ci_logical_datacenter] |
VM Instance [cmdb_ci_vm_instance]
| Attribute label | Attribute name |
|---|---|
| IP Address | ip_address |
| Name | name |
| Object ID | object_id |
| source_recency_timestamp | |
| State | state |
| Parent class | Relationship type | Child class |
|---|---|---|
| Virtual Machine Instance [cmdb_ci_vm_instance] | Hosted on::Hosts | Logical Datacenter [cmdb_ci_logical_datacenter] |
| Virtual Machine Instance [cmdb_ci_vm_instance] | Provisioned From::Provisioned | Image [cmdb_ci_os_template] |
| Virtual Machine Instance [cmdb_ci_vm_instance] | Provisioned From::Provisioned | Hardware Type [cmdb_ci_compute_template] |
| Virtual Machine Instance [cmdb_ci_vm_instance] | Use End Point To::Use End Point From | Storage Volume [cmdb_ci_storage_volume] |