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