Target Tables for n8n
Summarize
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 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
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 |
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 |
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
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 |
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
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 |
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
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
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
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 |