Target Tables for n8n

  • Release version: Australia
  • Updated March 12, 2026
  • 2 minutes to read
  • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Target Tables for n8n

    This content explains how ServiceNow customers can configure their integration with n8n to periodically pull data from n8n projects. The pulled data is stored in specific target tables within the ServiceNow platform, primarily extending from CMDB Configuration Item (CI) classes and other non-CMDB classes. This setup enables structured tracking of various AI-related components such as AI systems, models, prompts, tools, subcomponents, and usage metrics.

    Show full answer Show less

    Target Tables and Their Purpose

    The integration populates distinct tables categorized by AI system components, models, prompts, tools, subcomponents, and usage. Each table captures relevant attributes mapped from n8n data to enable comprehensive asset and configuration management.

    • AI Systems:
      • cmdbaisystemcomponentproductmodel - Stores attributes like name and version of AI system components.
      • almaisystemdigitalasset - Contains external reference IDs, connection URLs, display names, install status, AI models, and language models.
      • cmdbcifunctionai - Holds AI function details including name, object ID, install status, model ID, vendor, and system ID.
    • AI Models:
      • cmdbaimodelproductmodel - Captures model name and version.
      • almaimodeldigitalasset - Records external reference ID, connection URL, model name, and type version.
    • AI Prompts:
      • cdmbaipromptproductmodel - Stores prompt name, prompt information, parameters, and system messages.
      • almaipromptdigitalasset - Captures external reference ID, asset type, and asset ID.
    • AI Tools:
      • snentaitool - Includes external reference ID, workflow plus node names, description, and active status.
    • AI Subcomponents:
      • snentaisystemsubcomponentm2m - Maps AI systems to subcomponents using connection URLs, workflow IDs, and node IDs.
      • aisubcomponentreferencetable - References subcomponents such as agents or tools.
    • AI Usage:
      • snaidiscaiusage - Tracks AI system usage details including session ID, time, and execution count.

    Practical Implications for ServiceNow Customers

    By leveraging these target tables, customers can efficiently manage AI assets and their relationships within the ServiceNow platform. The structured data enables better visibility into AI workflows, components, models, prompts, and tool usage. This facilitates informed decision-making, compliance tracking, and enhanced operational management of AI systems integrated through n8n.

    When you complete setting up the connection, you can configure the integration to periodically pull data from a n8n project. The data is saved in tables that extend from the CMDB CI classes and other non-CMDB classes.

    Target Tables for AI systems

    cmdb_ai_system_component_product_model

    The following attributes in the n8n Datacenter [cmdb_ai_system_component_product_model] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    Name name name (workflow) or name (agent)
    Version version Type version
    alm_ai_system_digital_asset

    The following attributes in the n8n Datacenter [alm_ai_system_digital_asset] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    External Ref id external_ref_id Connection Url + data or connection Url + data+ nodes
    Display Name display_name Name
    Install Status Install_status Data is Archived
    AI Models ai_models AI Language model
    cmdb_ci_function_ai

    The following attributes in the n8n Datacenter [cmdb_ci_function_ai] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    Name name display name
    Object ID object_id external reference id
    Install status install_status Install status
    Model ID model_id model
    Vendor vendor vendor
    Sys id asset asset

    Target Tables for AI model

    cmdb_ai_model_product_model

    The following attributes in the n8n Datacenter [cmdb_ai_model_product_model] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    Name name Model name
    Version version Type version
    alm_ai_model_digital_asset

    The following attributes in the n8n Datacenter [alm_ai_model_digital_asset] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    External Ref ID external_ref_id Connection URL, model name, type version

    Target Tables for AI prompts

    cdmb_ai_prompt_product_model

    The following attributes in the n8n Datacenter [cdmb_ai_prompt_product_model] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    Name name Name
    Prompt Info prompt_info Parameters system message
    alm_ai_prompt_digital_asset

    The following attributes in the n8n Datacenter [alm_ai_prompt_digital_asset] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    External Ref ID external_ref_id Asset type, asset id

    Target Tables for AI tools

    sn_ent_ai_tool

    The following attributes in the n8n Datacenter [sn_ent_ai_tool] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    External ref id external_ref_id workflow +node
    Name name Nodes +toolType
    Description description nodes
    Active active nodes

    Target Tables for AI Subcomponents

    sn_ent_ai_system_subcomponent_m2m

    The following attributes in the n8n Datacenter [sn_ent_ai_system_subcomponent_m2m] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    AI System ai_system connectionUrl + workflowld + +nodeld or n8n
    AI Subcomponent ai_subcomponent connectionUrl + workflowld + nodeld (for sub sysems) or workflowld+ nodeld (for tools)
    AI subcomponent reference table ai_subcomponent_reference_table agents or tools

    Target Tables for AI Usage

    sn_ai_disc_ai_usage

    The following attributes in the n8n Datacenter [sn_ai_disc_ai_usage] table are populated by collected data.

    Attribute label Attribute name n8n attribute
    AI System ai_system connectionUrl+ workflowld + nodeld
    Session ID session_id data.id
    Time time runData.executions
    Count count runData.executions.length