CMDB classes targeted in Service Graph Connector for Microsoft SCCM
When you complete setting up the connection, you can configure the integration to periodically pull data from Microsoft SCCM. The data is saved in tables that extend from the Configuration item [cmdb_ci] table.
Computer [cmdb_ci_computer]
The following attributes in the Computer [cmdb_ci_computer] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Serial number | serial_number |
| CPU core count | cpu_core_count |
| CPU speed (MHz) | cpu_speed |
| CPU type | cpu_type |
| CPU manufacturer | cpu_manufacturer |
| Name | name |
| Asset tag | asset_tag |
| Assigned | assigned |
| Chassis type | chassis_type |
| Class | sys_class_name |
| CPU core thread | cpu_core_thread |
| CPU count | cpu_count |
| CPU name | cpu_name |
| Default Gateway | default_gateway |
| DNS Domain | dns_domain |
| Most recent discovery | last_discovered |
| Operating System | os |
| OS Address Width (bits) | os_address_width |
| OS Domain | os_domain |
| OS Service Pack | os_service_pack |
| OS Version | os_version |
| RAM (MB) | ram |
| Model ID | model_id |
| Manufacturer | manufacturer |
| Assigned to | assigned_to |
| Parent class | Relationship type | Child class |
|---|---|---|
| Computer [cmdb_ci_computer] | Owns::Owned by | Network Adapter [cmdb_ci_network_adapter] |
| Computer [cmdb_ci_computer] | Owns::Owned by | IP Address [cmdb_ci_ip_address] |
| Computer [cmdb_ci_computer] | Contains::Contained by | Disk [cmdb_ci_disk] |
| Computer [cmdb_ci_computer] | Reference | Key Value [cmdb_key_value] |
| Computer [cmdb_ci_computer] | Reference | Software Installation [cmdb_sam_sw_install] |
| Computer [cmdb_ci_computer] | Reference | SG-SCCM Computer Related [sn_sccm_integrate_sccm_2019_computer_related] |
Disk [cmdb_ci_disk]
The following attributes in the Disk [cmdb_ci_disk] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Disk space (GB) | disk_space |
| Size bytes | size_bytes |
| Computer | computer |
| Device ID | device_id |
| Name | name |
| Description | short_description |
| Drive type | drive_type |
| Manufacturer | manufacturer |
| Model ID | model_id |
| Parent class | Relationship type | Child class |
|---|---|---|
| Disk [cmdb_ci_disk] | Reference | Computer [cmdb_ci_computer] |
IP Address [cmdb_ci_ip_address]
The following attributes in the IP Address [cmdb_ci_ip_address] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| IP Address | ip_address |
| IP version | ip_version |
| Name | name |
| Nic | nic |
| Parent class | Relationship type | Child class |
|---|---|---|
| IP Address [cmdb_ci_ip_address] | Reference | Network Adapter [cmdb_ci_network_adapter] |
Key Value [cmdb_key_value]
The following attributes in the Key Value [cmdb_key_value] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Key | key |
| Value | value |
Network Adapter [cmdb_ci_network_adapter]
The following attributes in the Network Adapter [cmdb_ci_network_adapter] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| MAC Address | mac_address |
| Name | name |
| DHCP Enabled | dhcp_enabled |
| Netmask | netmask |
| Configuration Item | cmdb_ci |
| Parent class | Relationship type | Child class |
|---|---|---|
| Network Adapter [cmdb_ci_network_adapter] | Reference | Computer [cmdb_ci_computer] |
Serial Number [cmdb_serial_number]
The following attributes in the Serial Number [cmdb_serial_number] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Serial Number | serial_number |
| Serial Number Type | serial_number_type |
| Valid | valid |
| Parent class | Relationship type | Child class |
|---|---|---|
| Serial Number [cmdb_serial_number] | Reference | Computer [cmdb_ci_computer] |
SG-SCCM Computer Related [sn_sccm_integrate_sccm_2019_computer_related]
The following attributes in the SG-SCCM Computer Related [sn_sccm_integrate_sccm_2019_computer_related] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Resource ID | resource_id |
| OU Name | ou_name |
Software [cmdb_ci_spkg]
The following attributes in the Software [cmdb_ci_spkg] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Key | key |
| Name | name |
| Version | version |
| Vendor | vendor |
| Manufacturer | manufacturer |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software [cmdb_ci_spkg] | Reference | Software Instance [cmdb_software_instance] |
Software Installation [cmdb_sam_sw_install]
The following attributes in the Software Installation [cmdb_sam_sw_install] table are populated by collected data when the SAM application is installed:
| Attribute label | Attribute name |
|---|---|
| Publisher | publisher |
| Last scanned | last_scanned |
| Installed on | installed_on |
| Display name | display_name |
| Discovery source | discovery_source |
| Install date | install_date |
| Prod id | prod_id |
| Version | version |
| Revision | revision |
| Sccm group ID | sccm_group_id |
| SCCM TimeStamp | sccm_timestamp |
| Assigned to | assigned_to |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software Installation [cmdb_sam_sw_install] | Reference | Computer [cmdb_ci_computer] |
Software Instance [cmdb_software_instance]
The following attributes in the Software Instance [cmdb_software_instance] table are populated by collected data:
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Installed on | installed_on |
| Install date | install_date |
| Sccm group ID | sccm_group_id |
| SCCM TimeStamp | sccm_timestamp |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software Instance [cmdb_software_instance] | Reference | Computer [cmdb_ci_computer] |