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 labelAttribute 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
Table 1. Relationships created for Computer
Parent classRelationship typeChild 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 labelAttribute 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
Table 2. Relationship created for Disk
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 labelAttribute name
IP Address ip_address
IP version ip_version
Name name
Nic nic
Table 3. Relationship created for IP Address
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 labelAttribute name
MAC Address mac_address
Name name
DHCP Enabled dhcp_enabled
Netmask netmask
Configuration Item cmdb_ci
Table 4. Relationship created for Network Adapter
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
Table 5. Relationship created for Serial Number
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 labelAttribute name
Key key
Name name
Version version
Vendor vendor
Manufacturer manufacturer
Table 6. Relationship created for Software
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 labelAttribute 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
Table 7. Relationship created for Software Installation
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 labelAttribute name
Name name
Installed on installed_on
Install date install_date
Sccm group ID sccm_group_id
SCCM TimeStamp sccm_timestamp
Table 8. Relationship created for Software Instance
Parent class Relationship type Child class
Software Instance [cmdb_software_instance] Reference Computer [cmdb_ci_computer]