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
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 |