Tenable One Open Connector Mapping

Mapping Behavior and Limitations

This section outlines the expected behavior and logic rules that govern how source file columns are mapped to Tenable Exposure Management attributes during the Tenable One Open Connector configuration process.

These rules ensure consistent data transformation, populate fields accurately, and prevent unintended data loss. To successfully configure a data import using the Tenable One Open Connector, you must understand the logic behind standard one-to-one mappings, supported exceptions, and constraints that Tenable Exposure Management enforces.

Note: For a Database data source, your source columns are the columns that your SQL query returns. Every mapping rule in this topic applies to those columns in the same way. For more information, see Automated Pull from Database in Tenable One Open Connector.

Many-to-One Mapping Exceptions (Multi-Value Fields)

By default, if you map multiple source columns to a single-value Tenable Exposure Management attribute, the last mapped column overwrites previous values. However, the following fields accept data from multiple source columns and concatenate the values.

Supported Multi-Value Tenable Exposure Management Fields Ingestion Example
  • Asset > MAC Addresses
  • Asset > IPs (IPv4 Addresses)
  • Asset > External Tags
  • Asset > Custom Attributes
  • Finding > Custom Attributes

If you map several source columns (for example, ip1, ip2, and ip3) to Asset > IPs, Tenable Exposure Management concatenates the values into a comma-separated list during ingestion.

External Tags Prefixing Behavior

Tenable Exposure Management automatically adds context to mapped external tags.

Expected Behavior Purpose Example

When you map any column to Assets > External Tags, Tenable Exposure Management adds the source column name to the tag value.

This enables better filtering and traceability in Tenable Exposure Management.

If the column Business_Unit contains Finance, it becomes: Business_Unit: Finance.

Mandatory Fields

To proceed with syncing the connector, you must define certain mandatory fields. These fields vary based on the selected asset type.

For Assets:

Asset Type Required Fields
Device

At least one of the following:

  • Assets > Asset Name

  • Assets > IPv4 Addresses

  • Assets > Device System Type

Container Assets > Asset Name
Web Applications Assets > Asset Name
Resource (Cloud) Assets > Asset Name
Code Repository Assets > Asset Name
Account Asset Name, Account Type, and either AD Object GUID or External Identifier (ARN)
Group Asset Name, and either AD Object GUID or External Identifier (ARN)
Role Asset Name and External Identifier (ARN)

For Findings:

Attribute Required Fields
Finding Attributes (Common)

Severity

Findings > Finding Name Finding Name

Mapping Reference Tables

The following reference tables displays the available mapping options when configuring the Tenable One Open Connector. They are designed to help you align your source file columns with the correct Tenable Exposure Management attributes based on the selected asset type.

Tip: For full setup instructions and usage details, see Tenable One Open Connector.

Device Mapping

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Common) Assets > External Tags Maps all fields from the ingested type to be asset tags in the platform.
Assets> Created Date None
Assets > Last Observed At None
Assets > Custom Attributes Maps to general asset metadata that doesn't fit a standard field.
Asset Attributes (Device Specific) Assets > Asset Name None
Assets > Host Fully Qualified DNS Maps FQDN.
Assets > Operating Systems None
Assets > OS Version None
Assets > Device System Type Maps cloud_instance_id.
Assets > MAC Addresses None
Assets >  IPv4 Addresses None
Finding Attributes (Common) Findings > Finding Name Maps the title or name of the vulnerability and/or weakness.
Findings > Description Maps the description of the vulnerability and/or weakness.
Findings > Severity Maps CVSS score.
Findings > CVEs None
Findings > CWEs None
Findings > State Maps the findings status (e.g., Open, Fixed, Closed).
Findings > First Seen (observed) None
Findings > Last seen (Observed) None
Finding Attributes (Device Specific) Findings > Port None
Findings > Protocol None
Findings > Package Version None
Findings > Package None

Web Applications Mapping

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Common) Same as in Device (Common Finding Attributes) None
Asset Attributes (WebApp Specific) Assets > Asset Name Maps to the primary name or identifier of the web application.
Assets > Webapp Homepage Screenshot Url None
Finding Attributes (Common) Same as in Device (Common Finding Attributes) None
Finding Attributes (WebApp Specific) Findings > URL Maps The specific URL or endpoint where the finding was detected.

Resources (Cloud) Mapping

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Common) Same as Device (Custom Attributes, Tags, Dates) None
Asset Attributes (Cloud Resources Specific) Assets > Asset Name None
Assets >  Cloud Provider Maps the service provider (e.g., AWS, Azure, GCP).
Assets > Cloud Resource Type Maps the type of resource (e.g., S3 Bucket, Azure VM, GCP Instance).
Assets >  External Identifier Maps a unique identifier, typically the ARN or equivalent ID from the cloud provider.
Finding Attributes (Common) Same as in Device (Common Finding Attributes) None

Code Repository Mapping

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Common) Same as Device (Custom Attributes, Tags, Dates) None
Asset Attributes (Code Repository Specific) Assets > Asset Name None
Assets > Languages None
Assets > Last Commit Date None
Assets > Total Commits None
Assets > Contributors None
Assets > Owners None
Assets > Visibility Maps code repository access: Private or Public.
Assets > Asset Status Maps code repository status: Active, Archived, or Deleted.
Assets > Infrastructure Tools Maps infrastructure: Terraform, CloudFormation, Kubernetes YAML, or ARM.
Assets > Cloud Provider Name Maps the service provider, for example, AWS, Azure, or GCP.
Assets > Cloud Instance ID Maps a unique identifier, typically the ARN or equivalent ID from the cloud provider.
Finding Attributes (Common) Same as in Device (Common Finding Attributes) None
Finding Attributes (Code Repository Specific) Findings > Finding Type None
Findings > Finding Name None
Findings > Finding Category Maps the finding type: SAST, SCA, License, or IaC.
Findings > Vulnerability Published At Maps the vulnerability publish date.
Findings > Code Branch None
Findings > Code File Path None
Findings > Code Line Number None
Findings > Source Code Package Name None
Findings > Source Code Package Version None
Findings > Source Code Package Manager None
Findings > Score Maps the vendor finding score.
Findings > Solution Maps the vendor recommendation for the fix.
Findings > State None
Findings > Last Fixed At None
Findings > Proof None
Findings > Detection ID None
Findings > CVSS3 Base Vector None
Findings > Origin Finding URL Maps the issue page or vendor URL.

Identity Asset Type Mapping

The Account, Group, and Role asset types ingest identity data from Active Directory (AD) and Microsoft Entra ID (formerly Azure Active Directory). Most attributes apply to both sources. The Notes column identifies the attributes that apply to only one source.

The following table describes the identity asset types:

Asset Type Source Objects
Account Users, computers, devices, service principals, group managed service accounts (gMSAs), foreign security principals, and applications
Group AD groups and Entra ID groups
Role Entra ID directory roles

Account Mapping

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Account Specific) AD Object GUID AD only. The unique identifier of an AD account.
External Identifier Entra ID only. The object ID, which uniquely identifies an Entra ID account.
Provider Names The directory provider: ACTIVE_DIRECTORY or MICROSOFT_ENTRA_ID.
AD Distinguished Name AD only. For example, CN=Jane Doe,OU=Sales,DC=example,DC=com.
AD Object SID AD only. The security identifier (SID), for example, S-1-5-21-....
Account Login AD only. The user principal name (UPN), for example, [email protected].
Account Name The human-readable name of the account.
Account Type HUMAN, WORKLOAD, or DEVICE. For the value that matches each source object, see Account Type Values.
Account Status ACTIVE, DEACTIVATED, or DELETED.
MFA Flag Whether multifactor authentication (MFA) is enabled: True or False. Map this field when your source provides it.
AD Forest Name The fully qualified domain name (FQDN) of the domain or tenant, for example, example.onmicrosoft.com.
AD SAM Account Type AD only. The Security Account Manager (SAM) account name, for example, EXAMPLE\jdoe.
Asset Provider ID The object ID that the identity provider assigns.
Custom Attributes Any additional source attribute, for example, the tier zone (Tier 0 or Unclassified). For Entra ID, map the UPN to a custom attribute named UPN.
External Tags None
First Observation Date The date that the source first observed the account.
Last Observed At The date that the source last updated the account.
Asset Name None

Account Type Values

Map each source object to the following Account Type value:

Source Object Account Type
User (AD or Entra ID) HUMAN
Foreign security principal (AD) HUMAN
Computer (AD) DEVICE
Device (Entra ID) DEVICE
Service principal (Entra ID) WORKLOAD
Group managed service account (gMSA) (AD) WORKLOAD
Application registration (Entra ID) WORKLOAD

Group Mapping

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Group Specific) AD Object GUID AD only. The unique identifier of an AD group.
External Identifier Entra ID only. The group ID, which uniquely identifies an Entra ID group.
Provider Names The directory provider: ACTIVE_DIRECTORY or MICROSOFT_ENTRA_ID.
AD Distinguished Name AD only. For example, CN=Sales,OU=Groups,DC=example,DC=com.
AD Object SID AD only. The security identifier (SID), for example, S-1-5-21-....
Group Name The name of the group.
Asset Name Map the same source column as Group Name.
AD Forest Name The FQDN of the domain or tenant.
Group Is Privileged Whether the group is privileged: True or False.
Asset Provider ID The object ID that the identity provider assigns.
Custom Attributes Any additional source attribute.
External Tags None
First Seen The date that the source first observed the group.
Last Observed At The date that the source last updated the group.

Role Mapping

The Role asset type applies to Entra ID data only.

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Asset Attributes (Role Specific) External Identifier The role ID, which uniquely identifies the role.
Asset Provider ID The role ID.
Provider Names MICROSOFT_ENTRA_ID
Role Name The name of the role, for example, Global Administrator or Application Administrator.
Asset Name Map the same source column as Role Name.
Role Is Built-in Whether the role is a built-in role: True or False.
Role Is Privileged Whether the role is privileged: True or False.
Custom Attributes Any additional source attribute.
External Tags None
First Seen The date that the source first observed the role.
Last Observed At The date that the source last updated the role.

Identity Finding Mapping

Identity findings are misconfigurations on an account, group, or role. The same finding attributes apply to AD and Entra ID data.

Attributes in Source File Available Mapping Options in Tenable Exposure Management Notes
Finding Attributes (Identity Specific) Detection Name and Finding Name Map the name of the misconfiguration to both fields.
Description The description of the misconfiguration.
Severity Critical, High, Medium, Low, or None (informational).
Solutions The remediation steps and references.
State Active when the check failed, or Fixed when the check passed.
First Seen The date that the source first detected the misconfiguration.
Last Seen The date of the last check.
Custom Attributes Any additional source attribute, for example, the compliance frameworks or the last run score.

Suggested Uniqueness Criteria for Identity Asset Types

On the Data Aggregation and Uniqueness page, Tenable Exposure Management suggests the following uniqueness criteria for identity data. You can change the suggestions.

Entity Suggested Uniqueness Criteria
Account AD Object GUID for AD, or External Identifier for Entra ID
Group AD Object GUID for AD, or External Identifier for Entra ID
Role External Identifier (Entra ID)
Weakness Finding Name
Finding Finding Name and the unique identifier of the affected asset

Note: For all three identity asset types, Tenable Exposure Management suggests the Identity Tenable Exposure Category.