When you complete setting up the connection, you can configure the integration to periodically pull data from Microsoft Intune. 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
Name name
Serial number serial_number
Description short_description
Disk space (GB) disk_space
Manufacturer manufacturer
Operating System os
OS Version os_version
Model ID model_id
Assigned to assigned_to
Chassis type chassis_type
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] Reference SG-Intune Computer Related [sn_intune_integrat_computer_related]
Computer [cmdb_ci_computer] Reference Software Installation [cmdb_sam_sw_install]

Handheld Computing Device [cmdb_ci_handheld_computing]

The following attributes in the Handheld Computing Device [cmdb_ci_handheld_computing] table are populated by collected data:
Attribute labelAttribute name
Name name
Serial number serial_number
Description short_description
Disk space (GB) disk_space
IMEI imei
MEID meid
Operating System os
OS Version os_version
Phone Number phone_number
Root Access root_access
Model ID model_id
Carrier carrier
Assigned to assigned_to
Manufacturer manufacturer
Table 2. Relationships created for Handheld Computing Device
Parent classRelationship typeChild class
Handheld Computing Device [cmdb_ci_handheld_computing] Owns::Owned by Network Adapter [cmdb_ci_network_adapter]
Handheld Computing Device [cmdb_ci_handheld_computing] Owns::Owned by IP Address [cmdb_ci_ip_address]
Handheld Computing Device [cmdb_ci_handheld_computing] Reference SG-Intune Device Related [sn_intune_integrat_device_related]
Handheld Computing Device [cmdb_ci_handheld_computing] Reference Software Installation [cmdb_sam_sw_install]

Software Installation [cmdb_sam_sw_install]

The following attributes in the Software Installation [cmdb_sam_sw_install] table are populated by collected data:
Attribute labelAttribute name
Display name display_name
Version version
Discovery source discovery_source
Publisher publisher
Installed on installed_on
Note: The Publisher attribute is populated by the SG-Intune Software Reports data source only.
Table 3. Relationships created for Software Installation
Parent class Relationship type Child class
Software Installation [cmdb_sam_sw_install] Reference Handheld Computing Device [cmdb_ci_handheld_computing]

Computer [cmdb_ci_computer]

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
Configuration Item cmdb_ci
Table 4. Relationships created for Network Adapter
Parent class Relationship type Child class
Network Adapter [cmdb_ci_network_adapter] Reference Handheld Computing Device [cmdb_ci_handheld_computing]
Network Adapter [cmdb_ci_network_adapter] 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 version ip_version
Owned By Configuration Item owned_by_cmdb_ci
IP Address ip_address
Name name
Table 5. Relationships created for IP Address
Parent class Relationship type Child class
IP Address [cmdb_ci_ip_address] Reference Handheld Computing Device [cmdb_ci_handheld_computing]
IP Address [cmdb_ci_ip_address] 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 6. Relationships created for Serial Number
Parent class Relationship type Child class
Serial Number [cmdb_serial_number] Reference Handheld Computing Device [cmdb_ci_handheld_computing]
Serial number [cmdb_serial_number] Reference Computer [cmdb_ci_computer]

SG-Intune Computer Related [sn_intune_integrat_computer_related]

The following attributes in the SG-Intune Computer Related [sn_intune_integrat_computer_related] table are populated by collected data:
Attribute labelAttribute name
Device ID device_id
Azure AD Registered azure_ad_registered
Compliance State compliance_state
Device Enrollment Type device_enrollment_type
Email Address email_address
Encrypted is_encrypted
Managed Device Owner Type managed_device_owner_type
Management Agent management_agent
Supervised is_supervised

SG-Intune Device Related [sn_intune_integrat_device_related]

The following attributes in the SG-Intune Device Related [sn_intune_integrat_device_related] table are populated by collected data:
Attribute labelAttribute name
Device ID device_id
Azure AD Registered azure_ad_registered
Compliance State compliance_state
Device Category device_category
Device Enrollment Type device_enrollment_type
Device State device_state
Email Address email_address
Encrypted is_encrypted
Managed Device Owner Type managed_device_owner_type
Management Agent management_agent
Security Patch Level security_patch_level
Supervised is_supervised
System Management Bios Version system_management_bios_version
Wifi Subnet ID wifi_subnet_id
Note: The attributes Device Category, Device State, Security Patch Level, System Management Bios Version, and Wifi Subnet ID are populated by the SG-Intune Device Reports data source only.

The attributes Azure AD Registered, Device Enrollment Type, and Management Agent aren't populated by the SG-Intune Device Reports data source.

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
Table 7. Relationship created for Software
Parent class Relationship type Child class
Software [cmdb_ci_spkg] Reference Software Instance [cmdb_software_instance]

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
Table 8. Relationships created for Software Instance
Parent class Relationship type Child class
Software Instance [cmdb_software_instance] Reference Handheld Computing Device [cmdb_ci_handheld_computing]
Software Instance [cmdb_software_instance] Reference Computer [cmdb_ci_computer]