Rapid7 Cloud Native Application Protection Tables

The Rapid7 Cloud Native Application Protection integration uses the following tables.

Tables

Rapid7InsightCloudSecCloudAccounts

Contains details of cloud accounts configured and discovered in Rapid7 InsightCloudSec.

NameTypeDescription
ConfigIDintegerThe configuration ID
AccountIDstringThe unique identifier of the cloud account (AccountID)
BadgeCountintegerThe number of badges (tags/labels) on this account in InsightCloudSec
CloudAccessstringThe level of access granted to the cloud account
CloudOrganizationDomainNamestringThe domain name of the cloud organization (if applicable)
CloudOrganizationIDstringThe unique identifier of the cloud organization
CloudOrganizationNicknamestringThe nickname of the cloud organization
CloudTypeIDstringThe cloud provider type identifier (e.g. AWS, GCP, Azure)
CreationTimedatetimeThe timestamp when the cloud account was created in InsightCloudSec
DisabledResourceTypesstringComma-separated list of resource types disabled for this account
EventDrivenHarvestRolestringThe IAM role used for event-driven harvesting
FailedResourceTypesstringComma-separated list of resource types that failed to harvest
GroupResourceIDstringThe resource group ID that this account belongs to in InsightCloudSec
IDintegerThe primary key for this record
IsCompartmentbitWhether this account represents an OCI compartment
IsPlatformManagedbitWhether this account is managed by the platform
LastRefresheddatetimeThe last time this account’s data was refreshed in InsightCloudSec
NamestringThe display name of the cloud account
OwnerstringThe owner or principal responsible for the account
ResourceCountintegerThe total number of resources discovered under this account
ResourceIDstringThe internal resource identifier string for the account
RoleARNstringThe ARN of the role assumed to access this cloud account
ScanErrorstringAny error message encountered during the last scan
StatusstringThe current status of the cloud account in InsightCloudSec
StrategyIDintegerThe strategy ID used for harvesting this account
TenantIDstringThe tenant or subscription ID associated with the account
TrailblazerAccountInScopestringWhether this account is included in the Trailblazer audit scope
TrailblazerCloudtrailTrailsstringComma-separated list of CloudTrail trails monitored for this account
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecFindings

Contains detailed records of security findings generated by InsightCloudSec Insights, including metadata, severity, affected resources, and associated risk information.

NameTypeDescription
ConfigIDintegerIdentifier of the insight/configuration instance for this finding
IDintegerUnique identifier for this specific finding record.
AllintegerIndicator denoting that the finding applies across all resources/context in scope.
AuthorstringUser or system that created the insight template or finding.
CacheUpdatedAtdatetimeTimestamp when the cache for this record or related metadata was last refreshed.
CustomSeveritystringUser-assigned or override severity for this insight/finding.
DescriptionstringText description of the insight/finding: what it checks for and what the finding means.
DisabledstringFlag indicating whether this insight/configuration is disabled.
DurationintegerTime period or duration over which this finding was evaluated or applies.
ExemptionsintegerList or count of resource exemptions applied to this insight/configuration.
FavoritedbooleanFlag indicating that a user has marked this insight/finding as a favorite.
InsertedAtdatetimeTimestamp when this record was first inserted in the system.
IsDeprecatedbooleanFlag indicating the insight/template/configuration is deprecated.
MetaDatastringStructured additional metadata attached to the record for extra context.
NamestringName/title of the insight or finding record.
NotesstringFree-form notes or comments attached to this insight/finding.
OwnerResourceIDstringIdentifier of the resource that owns or is responsible for this finding.
ReleasedstringFlag or date indicating when the insight/template was released/published for use.
RemoveVersionstringVersion number of the template/configuration from which this insight was removed or marked for removal.
ResourceGroupBlackliststringList of resource groups that are excluded from evaluation by this insight/configuration.
ResourceTypesstringThe list of resource types (e.g., compute instance, storage bucket) that this insight targets or applies to.
ResultsintegerNumber or set of actual resultsthat failed or triggered this insight in the current run.
SeverityintegerDefault severity level of this insight (e.g., Low, Medium, High) before any custom overrides.
SourcestringOrigin or type of this finding (e.g., misconfiguration check, threat detection, IaC scan).
SupportedCloudsstringList of cloud providers (e.g., AWS, Azure, GCP) for which this insight is supported.
SupportedIacCloudsstringList of IaC (Infrastructure as Code) frameworks/clouds which this insight supports (e.g., Terraform, CloudFormation).
TagsstringKey/value tags attached to this insight/finding for categorization, filtering, or grouping.
TemplateIDstringIdentifier of the underlying insight template definition that this record is based on.
TotalintegerTotal number of resources evaluated for this insight in the current scope/run.
UpdatedAtdatetimeTimestamp when this record was last updated.
UserResourceIDstringIdentifier of the user that last modified or is responsible for this finding/insight.
VersionstringVersion number of the insight/template/configuration currently applied.
Rapid7InsightCloudSecInsightIDintegerInternal ID of the Insight within the InsightCloudSec system.
Rapid7InsightCloudSecInsightConfigIDintegerInternal ID of the specific insight configuration in InsightCloudSec.
Rapid7InsightCloudSecResourceIDstringInternal ID of the resource in InsightCloudSec that this finding is against.
Rapid7InsightCloudSecResourceConfigIDintegerInternal ID of the resource configuration snapshot in InsightCloudSec at the time of finding.
ResourceAccountIDstringIdentifier of the cloud account hat owns the resource under evaluation.
ResourceCloudstringCloud provider name of the resource (e.g., AWS, Azure, GCP) for which the finding applies.
BatchDatedatetimeDate of the ingestion/processing batch in which this finding record was created or updated.
AttackPathCountintegerNumber of attack-paths identified by InsightCloudSec that involve this resource.
PublicAccessiblebooleanFlag indicating whether the resource evaluated by this insight is publicly accessible as determined by the platform.
RiskScoreintegerNumeric risk score assigned to this finding/resource based on combined risk factors.
SensitiveDataHighintegerCount of high-severity sensitive data findings/classifications associated with this resource.
SensitiveDataLowintegerCount of low-severity sensitive data findings/classifications for this resource.
SensitiveDataMediumintegerCount of medium-severity sensitive data findings/classifications for this resource.
SensitiveDataStatusstringOverall status flag of sensitive data classification for the resource (e.g., none, detected, mitigated).

Rapid7InsightCloudSecInsightPacks

Contains definitions of Insight Packs available in Rapid7 InsightCloudSec.

NameTypeDescription
PackIDintegerThe unique identifier for the Insight Pack
ConfigIDintegerThe configuration ID
NamestringThe name of the Insight Pack
DescriptionstringA detailed description of the Insight Pack’s purpose
InsertedAtdatetimeThe timestamp when this pack record was first inserted
UpdatedAtdatetimeThe timestamp when this pack record was last updated
LogoUrlstringThe URL of the Insight Pack’s logo image
RemoveVersionstringThe version string indicating which insight was removed (if any)
SourcestringThe source of the pack (e.g., backoffice, custom)
SubscriptionsintegerThe number of subscriptions to this pack
IsDeprecatedbitWhether the pack is deprecated
LockedbitWhether the pack is locked from modification
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecInsightPackSupportedClouds

Maps each Insight Pack to the cloud platforms it supports.

NameTypeDescription
ConfigIDintegerThe configuration ID
CloudNamestringThe name of the supported cloud platform
BatchDatedatetimeThe date and time the data was retrieved from Rapid7
IDintegerThe Unique Identifier

Rapid7InsightCloudSecInsightResourceTypes

Stores which resource types are supported by insights for the given configuration.

NameTypeDescription
ConfigIDintegerThe configuration ID
ResourceTypestringThe supported resource type name (e.g. storagecontainer, instance)
BatchDatedatetimeThe date and time the data was retrieved from Rapid7
IDintegerThe Unique Identifier

Rapid7InsightCloudSecInsights

Insight definitions and metadata from Rapid7 InsightCloudSec for a given configuration

NameTypeDescription
ConfigIDintegerThe configuration ID
InsightIDintegerThe unique identifier of the insight
AllintegerThe total number of resources evaluated by this insight (including exempted)
AuthorstringThe source system or user who authored the insight
CacheUpdatedAtdatetimeThe timestamp when the cached results were last updated
CustomSeveritystringAny user-defined severity override for this insight
DescriptionstringA detailed description of what the insight checks for
DisabledstringIndicates if the insight is currently disabled
DurationfloatHow long the insight took to execute (in seconds)
ExemptionsintegerThe count of resources exempted from this insight
FavoritedbitFlag indicating if this insight is marked as a favorite
InsertedAtdatetimeWhen the insight definition was first inserted into the system
IsDeprecatedbitFlag indicating if the insight is deprecated
MetaDatastringAny additional metadata for the insight
NamestringThe human-readable name of the insight
NotesstringDeveloper or operator notes associated with the insight
OwnerResourceIDstringIdentifier for the resource owner context, if applicable
ReleasedstringThe version or release identifier when the insight was made available
RemoveVersionstringThe version when the insight was removed or deprecated
ResourceGroupBlackliststringAny resource groups excluded from this insight
ResultsintegerThe number of resources currently failing this insight
SeverityintegerThe default severity level of the insight (as an integer)
SourcestringThe origin of the insight (e.g. backoffice, core)
TemplateIDstringIdentifier for the underlying template used by the insight
TotalintegerThe total number of resources returned by the insight (before paging)
UpdatedAtdatetimeThe timestamp when the insight definition was last updated
UserResourceIDstringIdentifier for the user context, if applicable
VersionstringThe version number of the insight definition
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecInsightSupportedClouds

Stores which cloud platforms each insight supports, including when this data was retrieved.

NameTypeDescription
ConfigIDintegerThe configuration ID
CloudNamestringThe name of the supported cloud for the insight.
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecInsightSupportedIacClouds

Stores which Infrastructure-as-Code cloud platforms each insight supports, including when this information was retrieved.

NameTypeDescription
ConfigIDintegerThe configuration ID
IACCloudNamestringThe name of the supported Infrastructure-as-Code cloud for the insight.
BatchDatedatetimeThe date and time the data was retrieved from Rapid7
IDintegerThe Unique Identifier

Rapid7InsightCloudSecInsightTags

Stores associations between insights and their tags, including when they were retrieved.

NameTypeDescription
ConfigIDintegerThe configuration ID
TagstringThe tag text assigned to the insight.
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecIntegrations

Contains the settings and metadata for each InsightCloudSec integration configuration.

NameTypeDescription
IDintegerThe unique ID for the configuration
NamestringThe name of the configuration set up
IsEnabledbooleanIs the integration enabled
BaseURLstringThe base URL the integration uses for API calls to Rapid7
CreatedDatedatetimeThe date and time the configuration was created
ModifiedDatedatetimeThe date and time the configuration was modified
CreatedBystringThe user who created the configuration
ModifiedBystringThe user who modified the configuration
IntegrationIDintegerThe unique ID for the integration

Rapid7InsightCloudSecResourceActiveVulnerabilityReports

Holds active vulnerability assessment summaries for each resource, including counts by severity, risk scores, assessment status, and snapshot timestamps.

NameTypeDescription
ConfigIDintegerThe configuration ID
ResourceIDstringThe resource identifier for which this report applies
ReportIDstringThe unique identifier for the vulnerability report
CriticalCountintegerThe count of critical severity vulnerabilities in the latest assessment
HighCountintegerThe count of high severity vulnerabilities in the latest assessment
MediumCountintegerThe count of medium severity vulnerabilities in the latest assessment
LowCountintegerThe count of low severity vulnerabilities in the latest assessment
NoneCountintegerThe count of vulnerabilities classified as none severity in the latest assessment
TotalCountintegerThe total number of vulnerabilities in the latest assessment
RiskScorefloatThe aggregated risk score from the latest assessment
SeveritystringThe overall severity level determined by the assessment
PublicAccessiblebitIndicates whether the resource is publicly accessible
ImageIDstringThe identifier of the image scanned, if applicable
LastAssessmentdatetimeThe timestamp of the most recent assessment
AssessmentStartedAtdatetimeThe timestamp when the assessment process began
AssessmentMessageStartedAtdatetimeThe timestamp when the assessment messaging was initiated
AssessmentCompletedAtdatetimeThe timestamp when the assessment process completed
SnapshotCreatedAtdatetimeThe timestamp when the vulnerability snapshot was created
SnapshotCompletedAtdatetimeThe timestamp when the vulnerability snapshot process completed
AssessmentStatusstringThe current status of the assessment (e.g., COMPLETED, FAILED)
AssessmentErrorReasonstringThe reason for any assessment error, if applicable
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecResourceAdditionalDetails

Stores supplementary metadata in JSON format that provides extended details about individual InsightCloudSec resources beyond the core resource attributes.

NameTypeDescription
ResourceIDstringIdentifier of the resource in the system.
ConfigIDintegerIdentifier of the configuration record or harvest snapshot for the resource at the time the additional details were captured.
AdditionalDetailsJSONstringA JSON-formatted field containing supplementary metadata or attributes for the resource.
BatchDatedatetimeDate representing the ingestion or batch load run when these additional details were recorded.

Rapid7InsightCloudSecResources

Holds a snapshot of each discovered cloud resource for a given configuration, including identifiers, metadata, tags, and timestamps.

NameTypeDescription
ConfigIDintegerThe configuration ID
ResourceIDstringThe unique resource identifier assigned by InsightCloudSec
ResourceNamestringThe human-readable name of the resource
ResourceTypestringThe type of the resource (e.g. instance, storagecontainer)
CloudstringThe cloud provider of the resource (e.g. AWS, GCE)
AccountstringThe name of the account under which the resource exists
AccountIDstringThe account ID associated with the resource’s cloud account
AccountStatusstringThe current status of the resource’s account (e.g. REFRESH)
OrganizationServiceIDintegerThe identifier of the organization service that owns the resource
AutoIDintegerAn internal auto-incremented ID assigned by InsightCloudSec
ProviderIDstringThe provider-specific identifier for the resource
RegionstringThe geographic region where the resource resides
CreationTimestampdatetimeThe timestamp when the resource was created (if available)
DiscoveredTimestampdatetimeThe timestamp when the resource was first discovered by InsightCloudSec
ModifiedTimestampdatetimeThe timestamp when the resource was last modified in the cloud provider
NamespaceIDstringThe namespace or ARN that uniquely qualifies the resource
BatchDatedatetimeThe date and time the data was retrieved from Rapid7
Rapid7InsightCloudSecResourcesintegerInteger identifier that uniquely references a resource record within the InsightCloudSec Resources table.

Rapid7InsightCloudSecResourceTags

Contains the tag key-value pairs defined for resources in InsightCloudSec, representing metadata used for organization, filtering, and policy management.

NameTypeDescription
ConfigIDintegerThe configuration ID
TagstringThe tag value categorizing the resource
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecResourceTypes

Holds the count of each resource type for a given configuration at the snapshot time.

NameTypeDescription
ConfigIDintegerThe configuration ID
NamestringThe resource type name
CountintegerThe number of resources of this type
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Rapid7InsightCloudSecResourceVulnerabilities

Stores the vulnerability findings for each resource, keyed by CVE ID and resource.

NameTypeDescription
ConfigIDintegerThe configuration ID
CVEIDstringThe unique CVE identifier of the vulnerability
ResourceIDstringThe ID of the resource where this vulnerability was found
SeveritystringThe severity level of the vulnerability (e.g. CRITICAL, HIGH)
CVSSV2VectorstringThe CVSS v2 vector string describing the attack metrics
SourcestringThe origin of the vulnerability data (e.g. NVD, INSTANCE)
CVSSV2ScorefloatThe numeric CVSS v2 score
FirstFounddatetimeThe timestamp when this vulnerability was first detected on the resource
CVSSScorefloatThe overall CVSS score (default version)
CVSSV3ScorefloatThe numeric CVSS v3 score
URIstringThe URL linking to official details about the CVE
HasExploitsbitIndicates if known exploits exist for this vulnerability
AffectedPackagesintegerThe number of packages on the resource affected by this vulnerability
HasThreatsbitIndicates if known threat intelligence entries exist
ResourceCountintegerThe total number of resources globally affected by this CVE
TitlestringA human-readable summary or title of the vulnerability
RiskScorefloatA calculated risk metric combining severity and exposure
VulnerabilityIDstringAn internal or alternate vulnerability identifier
LastSeendatetimeThe timestamp when the vulnerability was last observed on the resource
CVSSV3VectorstringThe CVSS v3 vector string describing the attack metrics
ImageCountintegerThe number of container images affected (if applicable)
PublicResourceCountintegerThe count of publicly-accessible resources affected
PackageCountintegerThe total number of packages scanned on the resource
CweIdsJSONstringJSON-serialized list of CWE identifier(s)
DescriptionstringDetailed description of the vulnerability from metadata
FixedVersionstringThe version in which this vulnerability is resolved
PublishedDatedatetimeThe official publication date of the CVE
LastModifiedDatedatetimeThe timestamp when the CVE metadata was last updated
BatchDatedatetimeThe date and time the data was retrieved from Rapid7

Bridge Tables

Rapid7InsightCloudSecFindings_Rapid7InsightCloudSecInsightPacks

Maps security findings to the Insight Packs they belong to, linking each finding with its associated group or collection of Insights in InsightCloudSec.

NameTypeDescription
IDintegerThe Unique Identifier
ConfigIDintegerThe configuration ID
PackIDintegerThe unique identifier for the Insight Pack

Rapid7InsightCloudSecInsightPacks_Rapid7InsightCloudSecInsightPackSupportedClouds

Associates each Insight Pack with the cloud platforms it supports.

NameTypeDescription
PackIDintegerThe unique identifier of the Insight Pack
ConfigIDintegerThe configuration ID
CloudNamestringThe name of the supported cloud platform

Rapid7InsightCloudSecInsights_Rapid7InsightCloudSecInsightPacks

Associates each insight with the packs it belongs to.

NameTypeDescription
InsightIDintegerThe unique identifier of the insight
ConfigIDintegerThe configuration ID
PackIDintegerThe unique identifier of the insight pack

Rapid7InsightCloudSecInsights_Rapid7InsightCloudSecInsightResourceTypes

Associates each insight with the resource types it applies to.

NameTypeDescription
InsightIDintegerThe unique identifier of the insight
ConfigIDintegerThe configuration ID
ResourceTypestringThe name of the resource type that this insight targets

Rapid7InsightCloudSecInsights_Rapid7InsightCloudSecInsightSupportedClouds

Associates each insight with the clouds it supports.

NameTypeDescription
InsightIDintegerThe unique identifier of the insight
ConfigIDintegerThe configuration ID
CloudNamestringThe name of the cloud that this insight supports

Rapid7InsightCloudSecInsights_Rapid7InsightCloudSecInsightSupportedIacClouds

Associates each insight with its supported Infrastructure-as-Code cloud platforms.

NameTypeDescription
InsightIDintegerThe unique identifier of the insight
ConfigIDintegerThe configuration ID
IACCloudNamestringThe name of the supported IaC cloud platform

Rapid7InsightCloudSecInsights_Rapid7InsightCloudSecInsightTags

Associates insights with their tags, capturing which tags apply to each insight.

NameTypeDescription
InsightIDintegerThe unique identifier of the insight
ConfigIDintegerThe configuration ID
TagstringThe tag value categorizing the insight

Rapid7InsightCloudSecInsights_Rapid7InsightCloudSecResources

Maps each insight to the resources it applies to.

NameTypeDescription
InsightIDintegerThe unique identifier of the insight
ConfigIDintegerThe configuration ID
ResourceIDstringThe identifier of the resource

Rapid7InsightCloudSecResources_Rapid7InsightCloudSecResourceTags

Links resources to their associated tags, enabling categorization and filtering of InsightCloudSec resources by tag metadata.

NameTypeDescription
TagstringThe tag value categorizing the resource
ConfigIDintegerThe configuration ID
ResourceIDstringThe unique resource identifier


Did this page help you?