CMDB classes targeted in Service Graph Connector for Microsoft Intune
Summarize
Summary of CMDB classes targeted in Service Graph Connector for Microsoft Intune
The Service Graph Connector for Microsoft Intune enables ServiceNow customers to integrate and synchronize device and software data from Microsoft Intune into their Configuration Management Database (CMDB). The integration periodically pulls data from both regular and advanced Microsoft Intune data sources, populating key CMDB tables that extend from the baseConfiguration Item [cmdbci]table.
Show less
CMDB Classes and Attributes Populated
- Computer [cmdbcicomputer]: Populates essential attributes including name, serial number, description, disk space, manufacturer, operating system details, model ID, chassis type, and assigned user.
- Handheld Computing Device [cmdbcihandheldcomputing]: Captures device-specific attributes such as IMEI, MEID, phone number, root access, carrier, along with standard fields like name, serial number, OS, model ID, and manufacturer.
- Software Installation [cmdbsamswinstall]: Includes software display name, version, discovery source, publisher (from advanced data source), and installation target.
- Network Adapter [cmdbcinetworkadapter]: Contains MAC address, name, and references to associated configuration items.
- IP Address [cmdbciipaddress]: Stores IP address, IP version, ownership to configuration items, and name.
- Serial Number [cmdbserialnumber]: Holds serial number details including type and validity.
- SG-Intune Computer Related [snintuneintegratcomputerrelated] and SG-Intune Device Related [snintuneintegratdevicerelated]: Custom tables capturing Intune-specific attributes such as device ID, Azure AD registration, compliance state, enrollment type, encryption status, management agent, supervision status, and additional device report details like device category, device state, security patch level, BIOS version, and WiFi subnet ID.
- Software [cmdbcispkg]: Includes key software details like key, name, and version.
- Software Instance [cmdbsoftwareinstance]: Captures software instance name and the device on which it is installed.
Key Relationships
The integration establishes relationships between these classes to maintain accurate and comprehensive CMDB data, such as:
- Ownership: Computers and handheld devices own network adapters and IP addresses.
- References: Devices and computers reference related software installations and Intune-specific related tables.
- Associations: Software installations link back to the devices (computers or handheld) where they are installed.
Practical Benefits for ServiceNow Customers
By leveraging this integration, ServiceNow customers can expect:
- Automated, up-to-date inventory of Microsoft Intune-managed devices and software within the CMDB.
- Enhanced visibility into device attributes, compliance status, and software deployments directly from Intune data.
- Accurate relationship mapping between devices, their network components, and installed software for improved asset and configuration management.
- Support for advanced Intune reporting data to enrich CMDB records with additional device metadata.
When you complete setting up the connection, you can configure the integration to periodically pull data from Microsoft Intune. The data from the regular data sources (SG-Intune Computer, SG-Intune Devices, and SG-Intune Software) and the advanced data sources (SG-Intune Device Reports and SG-Intune Software Reports) is saved in tables that extend from the Configuration item [cmdb_ci] table.
Computer [cmdb_ci_computer]
| Attribute label | Attribute 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 |
| 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] | 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]
| Attribute label | Attribute 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 |
| Parent class | Relationship type | Child 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]
| Attribute label | Attribute name |
|---|---|
| Display name | display_name |
| Version | version |
| Discovery source | discovery_source |
| Publisher | publisher |
| Installed on | installed_on |
| 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]
| Attribute label | Attribute name |
|---|---|
| MAC Address | mac_address |
| Name | name |
| Configuration Item | cmdb_ci |
| 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]
| Attribute label | Attribute name |
|---|---|
| IP version | ip_version |
| Owned By Configuration Item | owned_by_cmdb_ci |
| IP Address | ip_address |
| Name | name |
| 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]
| 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 | 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]
| Attribute label | Attribute 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]
| Attribute label | Attribute 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 |
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]
| Attribute label | Attribute name |
|---|---|
| Key | key |
| Name | name |
| Version | version |
| Parent class | Relationship type | Child class |
|---|---|---|
| Software [cmdb_ci_spkg] | Reference | Software Instance [cmdb_software_instance] |
Software Instance [cmdb_software_instance]
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Installed on | installed_on |
| 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] |