CMDB classes targeted in the Service Graph Connector Integration for Claroty CTD

  • Release version: Washingtondc
  • Updated July 19, 2024
  • 7 minutes to read

    • When you complete the setup tasks, you can configure the integration periodically to pull data from Claroty CTD. 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
    Most recent discovery last_discovered
    Operating System os
    OS Version os_version

    External system metadata [cmdb_key_value_v2]

    The following attributes in the External system metadata [cmdb_key_value_v2] table are populated by collected data:
    Attribute label Attribute name
    Discovery source discovery_source
    Key key
    Source key source_key
    URL value url_value
    Value type value_type

    Hardware [cmdb_ci_hardware]

    The following attributes in the Hardware [cmdb_ci_hardware] table are populated by collected data:
    Attribute label Attribute name
    Change Group assignment_group
    Support group support_group
    Company company
    Vendor vendor
    Name name
    Serial number serial_number
    Class sys_class_name
    First discovered first_discovered
    Location location
    Model number model_number
    Most recent discovery last_discovered
    Supported by supported_by
    Assigned to assigned_to
    Managed By Group managed_by_group
    Managed by managed_by
    Model ID model_id
    Approval group change_control
    Owned by owned_by
    Manufacturer manufacturer
    Table 1. Relationships created for Hardware
    Parent class Relationship type Child class
    Hardware [cmdb_ci_hardware] Owns::Owned by Network Adapter [cmdb_ci_network_adapter]
    Hardware [cmdb_ci_hardware] Owns::Owned by IP Address [cmdb_ci_ip_address]
    Hardware [cmdb_ci_hardware] Reference OT Device [cmdb_ot_entity]
    Hardware [cmdb_ci_hardware] Reference External system metadata [cmdb_key_value_v2]
    Hardware [cmdb_ci_hardware] Reference Software Installation [cmdb_sam_sw_install]

    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
    Owned By Configuration Item owned_by_cmdb_ci
    IP Address ip_address
    IP version ip_version
    Table 2. Relationships created for IP Address
    Parent class Relationship type Child class
    IP Address [cmdb_ci_ip_address] Network Intrusion Detection System [cmdb_ci_nids]
    IP Address [cmdb_ci_ip_address] Hardware [cmdb_ci_hardware]

    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
    Table 3. Relationships created for Network Adapter
    Parent class Relationship type Child class
    Network Adapter [cmdb_ci_network_adapter] Reference Hardware [cmdb_ci_hardware]

    Network Intrusion Detection System [cmdb_ci_nids]

    The following attributes in the Network Intrusion Detection System [cmdb_ci_nids] table are populated by collected data:
    Attribute label Attribute name
    Manufacturer manufacturer
    Name name
    Correlation ID correlation_id
    Description short_description
    Firmware version firmware_version
    NIDS manager connection state connection_state
    Life Cycle Stage Status life_cycle_stage_status
    Life Cycle Stage life_cycle_stage
    Validated validated
    Table 4. Relationships created for NIDS
    Parent class Relationship type Child class
    Network Intrusion Detection System [cmdb_ci_nids] Owns::Owned by IP Address [cmdb_ci_ip_address]
    Network Intrusion Detection System [cmdb_ci_nids] Detects::Detected by Hardware [cmdb_ci_hardware]

    Operational Technology (OT) [cmdb_ci_ot]

    The following attributes in the Operational Technology (OT) [cmdb_ci_ot] table are populated by collected data:
    Attribute label Attribute name\
    Firmware version firmware_version
    Most recent discovery last_discovered

    OT Device [cmdb_ot_entity]

    The following attributes in the OT Device [cmdb_ot_entity] table are populated by collected data:
    Attribute label Attribute name
    Purdue level purdue_level
    ISA entity site isa_entity_site
    OT discovery source ID ot_correlation_id
    Device criticality business_criticality
    Zone zone
    OT device type ot_asset_type

    OT Control Module [cmdb_ci_ot_control_module]

    The following attributes in the OT Control Module [cmdb_ci_ot_control_module] table are populated by collected data:
    Attribute label Attribute name
    Location location
    Supported by supported_by
    Name name
    Serial number serial_number
    Slot number slot_number
    Manufacturer manufacturer
    Firmware version firmware_version
    Approval group change_control
    Assigned to assigned_to
    Most recent discovery last_discovered
    Model ID model_id
    Model number model_number
    Company company
    Owned by owned_by
    Managed by managed_by
    Support group support_group
    Managed By Group managed_by_group
    Change Group assignment_group
    Vendor vendor
    Table 5. Relationships created for OT Control Module
    Parent class Relationship type Child class
    OT Control Module [cmdb_ci_ot_control_module] Reference OT Device [cmdb_ot_entity]

    OT Control System [cmdb_ci_ot_control]

    The following attributes in the OT Control System [cmdb_ci_ot_control] table are populated by collected data:
    Attribute label Attribute name
    Has module has_module
    Most recent discovery last_discovered
    Table 6. Relationships created for OT Control System
    Parent class Relationship type Child class
    OT Control System [cmdb_ci_ot_control] Owns::Owned by OT Control Module [cmdb_ci_ot_control_module]

    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 7. Relationships created for Serial Number
    Parent class Relationship type Child class
    Serial Number [cmdb_serial_number] Reference Hardware [cmdb_ci_hardware]

    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
    Version version
    Manufacturer manufacturer
    Name name
    Table 8. Relationships 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
    Install date install_date
    Installed on installed_on
    Name name
    Table 9. Relationships created for Software Instance
    Parent class Relationship type Child class
    Software Instance [cmdb_software_instance] Reference Hardware [cmdb_ci_hardware]

    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
    Table 10. Relationships created for Software Installation
    Parent class Relationship type Child class
    Software Instance [cmdb_software_instance] Reference Hardware [cmdb_ci_hardware]

    Default class mapping

    A default class mapping is shipped with the Service Graph Connector Integration for Claroty CTD application.

    Note:
    You can find the class mapping in the sn_clarotyctdsgc.SGOTClarotyCTDConstants script.
    Claroty CTD Type ServiceNow Type Class OT Entity Type Claroty Types and Codes
    eAAAServer (Empty)​ cmdb_ci_server​ eAAAServer = 61​
    eAccessControl​ (Empty)​ cmdb_ci_iot​ eAccessControl = 50​
    eAccessPoint​ (Empty)​ cmdb_ci_ip_switch​ eAccessPoint = 60​
    eADServer​ (Empty)​ cmdb_ci_server​ eADServer = 33​
    eAutonomousVehicle​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eAutonomousVehicle = 58​
    eAVServer​ (Empty)​ cmdb_ci_server​ eAVServer = 32​
    eBarcodeScanner​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eBarcodeScanner = 48​
    eBluetoothDevice​ (Empty)​ cmdb_ci_iot​ eBluetoothDevice = 41​
    eBroadcast​ (Empty)​ cmdb_ci_netgear​ eBroadcast = 4​
    eCamera​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eCamera = 42​
    eCleaningDevice​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eCleaningDevice = 55​
    eController​ OT Control System​ cmdb_ci_ot_control​ ot_control_system​ eController = 20​
    eDataLogger​ OT Control System​ cmdb_ci_ot_control​ ot_control_system​ eDataLogger = 66​
    eDBServer​ (Empty)​ cmdb_ci_server​ eDBServer = 35​
    eDomainController​ (Empty)​ cmdb_ci_server​ eDomainController = 5​
    eElectricalDrive​ Industrial Drive​ cmdb_ci_ot_industrial_drive​ industrial_drive​ eElectricalDrive = 68​
    eEndpoint​ Operational Technology Device​ cmdb_ci_ot​ ot_base​ eEndpoint = 2​
    eEngineeringStation​ EWS cmdb_ci_ot_ews​ ews eEngineeringStation = 14​
    eFileServer​ (Empty)​ cmdb_ci_server​ eFileServer = 10​
    eFirewall​ (Empty)​ cmdb_ci_ip_firewall​ eFirewall = 31
    eFrontEndProcessor​ OT Control System​ cmdb_ci_ot_control​ ot_control_system​ eFrontEndProcessor = 26​
    eGateway​ (Empty)​ cmdb_ci_ip_switch​ eGateway = 15​
    eGPSClock​ Operational Technology Device​ cmdb_ci_ot​ ot_base​ eGPSClock = 37​
    eGPSDevice​ Operational Technology Device​ cmdb_ci_ot​ ot_base​ eGPSDevice = 62​
    eHistorian​ Historian cmdb_ci_ot_historian​ historian eHistorian = 9​
    eHMI​ HMI cmdb_ci_ot_hmi​ hmi eHMI = 1​
    eHomeAssistant​ (Empty)​ cmdb_ci_iot​ eHomeAssistant = 53​
    eIED​ IED cmdb_ci_ot_ied​ ied eIED = 19​
    eInfusionPump (Empty)​ cmdb_ci_iot​ eInfusionPump = 46
    eMediaServer​ (Empty)​ cmdb_ci_server​ eMediaServer = 54​
    eMedicalDevice​ (Empty)​ cmdb_ci_iot​ eMedicalDevice = 47​
    eMicroscope​ (Empty)​ cmdb_ci_iot​ eMicroscope = 49​
    eModem​ (Empty)​ cmdb_ci_netgear​ eModem = 27​
    eMotorStarter​ Industrial Drive cmdb_ci_ot_industrial_drive​ industrial_drive​ eMotorStarter = 69​
    eNetworkAccessStorage​ (Empty)​ cmdb_ci_server​ eNetworkAccessStorage = 30​
    eNetworking​ (Empty)​ cmdb_ci_netgear​ eNetworking = 3​
    eNTPServer​ (Empty)​ cmdb_ci_server​ eNTPServer = 21​
    eOPCServer​ OPC Server​ cmdb_ci_ot_opc_server​ opc_server eOPCServer = 16​
    eOT​ Operational Technology Device​ cmdb_ci_ot​ ot_base​ eOT = 17​
    ePLC​ PLC cmdb_ci_ot_plc​ plc ePLC = 0​
    ePrinter​ (Empty) cmdb_ci_printer​ ePrinter = 6​
    eProxyServer​ (Empty) cmdb_ci_netgear​ eProxyServer = 28​
    eRemoteIO​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eRemoteIO = 13
    eReverseProxyServer​ (Empty)​ cmdb_ci_netgear​ eReverseProxyServer = 29​
    eRobot​ Industrial Robot​ cmdb_ci_ot_industrial_robot​ industrial_robot​ eRobot = 57​
    eRouter​ Router cmdb_ci_ip_router​ eRouter = 11​
    eRTU​ RTU cmdb_ci_ot_rtu​ rtu​ eRTU = 18​
    eSCADAClient​ SCADA Client​ cmdb_ci_ot_scada_client​ scada_client​ eSCADAClient = 7​
    eSCADAMaster​ SCADA Server​ cmdb_ci_ot_scada_server​ scada_server​ eSCADAMaster = 38​
    eSCADAServer​ SCADA Server​ cmdb_ci_ot_scada_server​ scada_server​ eSCADAServer = 8​
    eSensor​ Industrial Sensor​ cmdb_ci_ot_industrial_sensor​ industrial_sensor​ eSensor = 67​
    eSmartLight​ (Empty)​ cmdb_ci_iot​ eSmartLight = 51​
    eSmartPhone​ (Empty)​ cmdb_ci_iot​ eSmartPhone = 44​
    eSmartWatch​ (Empty)​ cmdb_ci_iot​ eSmartWatch = 45​
    eStorageArray​ (Empty)​ cmdb_ci_server​ eStorageArray = 36​
    eStreamer​ (Empty)​ cmdb_ci_iot​ eStreamer = 52​
    eSwitch​ (Empty)​ cmdb_ci_ip_switch​ eSwitch = 12​
    eSyslogServer​ (Empty)​ cmdb_ci_server​ eSyslogServer = 25​
    eTerminalServer (Empty)​ cmdb_ci_server​ eTerminalServer = 24
    eTVScreen​ (Empty)​ cmdb_ci_iot​ eTVScreen = 40​
    eUPS (Empty)​ cmdb_ci_ups​ eUPS = 63​
    eUserConsole​ HMI cmdb_ci_ot_hmi​ hmi eUserConsole = 22​
    eUserWorkstation​ HMI cmdb_ci_ot_hmi​ hmi eUserWorkstation = 23​
    eVendingMachine​ (Empty)​ cmdb_ci_iot​ eVendingMachine = 43​
    eVideoRecorder​ (Empty)​ cmdb_ci_server​ eVideoRecorder = 64​
    eVirtualizationServer​ (Empty)​ cmdb_ci_server​ eVirtualizationServer = 65​
    eVoipPhone​ (Empty)​ cmdb_ci_comm_hardware​ eVoipPhone = 39​
    eVoipServer​ (Empty)​ cmdb_ci_server​ eVoipServer = 56​
    eWebServer​ (Empty)​ cmdb_ci_server​ eWebServer = 34​
    eWirelessLanController​ (Empty)​ cmdb_ci_netgear​ eWirelessLanController = 59​
    eBarcodeReader​ (Empty)​ cmdb_ci_iot​ eBarcodeReader = 77​
    eBiometricScanner​ (Empty)​ cmdb_ci_iot​ eBiometricScanner = 74​
    eDNSServer​ (Empty)​ cmdb_ci_server​ eDNSServer = 75​
    eSNMPScanner​ (Empty)​ cmdb_ci_server​ eSNMPScanner = 73​
    eSNMPServer​ (Empty)​ cmdb_ci_server​ eSNMPServer = 72​
    eVisionCamera​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eVisionCamera = 76​
    eVisionController​ OT Control System​ cmdb_ci_ot_control​ ot_control_system​ eVisionController = 78​
    eVisionSensor​ OT Field Device​ cmdb_ci_ot_field_device​ ot_field_device​ eVisionSensor = 79​
    eVOIPAccessPoint​ (Empty)​ cmdb_ci_ip_switch​ eVOIPAccessPoint = 71​
    eVulnerabilityScanner​ (Empty)​ cmdb_ci_server​ eVulnerabilityScanner = 70​