Targeted CMDB classes in Service Graph Connector for Active Directory
When you complete setting up the connection, you can configure the integration to periodically pull data. 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 |
|---|---|
| Name | name |
| Category | category |
| Object ID | object_id |
| Fully qualified domain name | fqdn |
| Checked out | check_out |
| Check in | check_in |
| First discovered | first_discovered |
| Operating System | os |
| OS Version | os_version |
Software [cmdb_ci_spkg]
The following attributes in the Software [cmdb_ci_spkg] table are populated by collected data.
| Attribute label | Attribute name |
|---|---|
| Name | name |
| Key | key |
| Version | version |
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 |
| Install On | installed_on |
| Product Name | software |
Software Installation [cmdb_sam_sw_install]
The following attributes in the Software Installation [cmdb_sam_sw_install] table are populated by collected data.
| Attribute label | Attribute name |
|---|---|
| Display Name | display_name |
| Version | version |
| Discovery source | discovery_source |
SGC Active Directory Computer [sn_sec_sgc_ad_active_directory_computer]
The following attributes in the SGC Active Directory Computer [sn_sec_sgc_ad_active_directory_computer] table are populated by collected data.
| Attribute label | Attribute name |
|---|---|
| Account expires | account_expires |
| Bad password count | bad_pwd_count |
| Bad password time | bad_password_time |
| Code page | code_page |
| Common name | cn |
| Country code | country_code |
| Description | description |
| Display name | display_name |
| Distinguished name | distinguished_name |
| DN | dn |
| Dscorepropagation data | dscore_propagation_data |
| Instance type | instance_type |
| Iscritical system object | iscritical_system_object |
| Keywords | keywords |
| Last logon | last_logon |
| Local policy flags | local_policy_flags |
| Logon count | logon_count |
| Member of | member_of |
| Ms-DS-Host service account | msds_host_service_account |
| Ms-DS-Supported encryption types | msds_support_ncryptiontypes |
| Name | name |
| Object class | object_class |
| Object GUID | object_guid |
| Other well known objects | other_well_known_objects |
| Password last set | pwd_last_set |
| Primary group id | primary_groupid |
| SamAccount name | sam_account_name |
| SamAccount type | sam_account_type |
| Service binding information | service_binding_information |
| Service class name | service_class_name |
| Service DNS name | service_dns_name |
| Service DNS name type | service_dns_name_type |
| Service principal name | service_principal_name |
| Show in advanced view only | show_in_advanced_view_only |
| Source | source |
| User account control | user_account_control |
| USN changed | usn_changed |
| USN created | usn_created |
| When changed | when_changed |