Purpose
The Databucket Core Data Product is an inventory of your cloud storage resources, such as object storage buckets and managed file-storage services. Use it to answer questions such as which storage resources are publicly accessible, which are unencrypted, and which have no backup configured, and to join back to OCSF activity and findings that involve those resources.
Entity Correlation
The Entity Correlator identifies a cloud asset by its unique ID (uid), for example an Amazon Resource Name. For this resource, Entity Correlator looks at the resource_details.type_id = 2 (Databucket) and the resource_details.uid from the feed populating OCSF class 5023. When several feeds report the same uid, they are merged into a single asset with a single id.
Understanding the Table
An asset appears in this table when the feed that reports it classifies it as a databucket (type ID 2). Assets that a feed reports without a type are not placed in any of the cloud-asset tables.
The end_time field is populated when an asset is closed. This can happen because the source reports it as decommissioned, or no feed has reported it in the retention period (365 days by default, configurable). A closed asset has active = FALSE. If a closed asset is reported again, it is tracked as a new asset with a new id.
Security attributes such as is_public, is_encrypted and encryption_details are populated only when the reporting feed supplies them. If a feed does not supply these details, the value is null, not false.
Joining to CDPs and OCSF
OCSF event tables that reference cloud resources carry the asset in their resources array, and each element's id matches the CDP id. Join on that element to find the activity and findings that involve a storage resource.
Schema
Example Queries
Find all active databuckets
SELECT * FROM databucket WHERE active=TRUEFind the latest record for a given id
SELECT * FROM databucket WHERE active=TRUE AND id={id}Find publicly accessible buckets that are not encrypted
SELECT id, name, uid
FROM databucket
WHERE active=TRUE
AND is_public=TRUE
AND is_encrypted=FALSEFind storage resources with no backup configured
SELECT id, name, uid
FROM databucket
WHERE active=TRUE
AND is_backed_up=FALSECDP Data Dictionary
Caption | Name | Requirement | Type | Description |
|---|---|---|---|---|
Active | active | optional | boolean_t | ResourceDetails.end_time: The timestamp of when the resource was decommissioned or removed from tracking. Using the start_time and end_time together bound the time when a particular resource state is valid. If there is no end_time it tells the analyst that this is the current state of the resource. |
Created Time | created_time | optional | timestamp_t | ResourceDetails.created_time: The time when the resource was created. |
Criticality | criticality | optional | string_t | ResourceDetails.criticality: The criticality of the resource as defined by the event source. |
Description | desc | optional | string_t | ResourceDetails.desc: The description of the resource. |
Data | encryption_details | optional | string_t | ResourceDetails.data: Additional data describing the resource. |
End Time | end_time | optional | timestamp_t | ResourceDetails.end_time: The timestamp of when the resource was decommissioned or removed from tracking. Using the start_time and end_time together bound the time when a particular resource state is valid. If there is no end_time it tells the analyst that this is the current state of the resource a |
First Seen Time | first_seen_time | optional | timestamp_t | ResourceDetails.backtrace: This object is a key value set that relates each field in the entity to the raw event that gave DataBee that particular value in the correlation. |
Groups Name | groups | optional | string_t Array | ResourceDetails.groups: The groups to which the resource belongs. Group.name: The group name. |
History ID | hid | optional | integer_t | ResourceDetails.hid: The unique DataBee ID to identify a particular history entry or row in an entity table (i.e., user, device or product table). This field is the primary key and should not be mapped manually as the DataBee product populates this field itself. |
Hostname | hostname | recommended | string_t | ResourceDetails.hostname: The fully qualified name of the resource. |
ID | id | required | integer_t | ResourceDetails.id: The unique identifier used by DataBee for a specific cloud asset. This is the primary key for the Resource Details table and is referenced as 'resource_id' in activity and event tables to link to this cloud asset. Enables joins and correlations with events and activities. Synonym |
IP Address | ip | recommended | string_t | ResourceDetails.ip: The IP address of the resource, in either IPv4 or IPv6 format. |
Back Ups Configured | is_backed_up | optional | boolean_t | ResourceDetails.is_backed_up: Indicates whether the device or resource has a backup enabled, such as an automated snapshot or a cloud backup. For example, this is indicated by the |
Data | is_encrypted | optional | boolean_t | ResourceDetails.data: Additional data describing the resource. |
Data | is_public | optional | boolean_t | ResourceDetails.data: Additional data describing the resource. |
Labels | labels | optional | string_t Array | ResourceDetails.labels: The list of labels associated to the resource. |
Modified Time | modified_time | optional | timestamp_t | ResourceDetails.modified_time: The time when the resource was last modified. |
Name | name | recommended | string_t | ResourceDetails.name: The name of the resource. |
Namespace | namespace | optional | string_t | ResourceDetails.namespace: The namespace is useful when similar entities exist that you need to keep separate. |
Owner | owner | recommended | string_t | ResourceDetails.owner: The identity of the service or user account that owns the resource. |
Record Created At | record_created_at | required | timestamp_t | CDPs generated timestamp when record was created. |
Record Updated At | record_updated_at | required | timestamp_t | CDPs generated timestamp when record was last updated. |
Size | size | optional | string_t | ResourceDetails.size: The size of the resource in bytes. |
Tags | tags | optional | string_t | ResourceDetails.tags: The list of tags; |
Type | type | optional | string_t | ResourceDetails.type: The resource type as defined by the event source. |
Type ID | type_id | recommended | integer_t | ResourceDetails.type_id: The normalized identifier of the resource's type. |
Unique ID | uid | recommended | string_t | ResourceDetails.uid: The unique identifier of the resource. |
Version | version | optional | string_t | ResourceDetails.version: The version of the resource. For example |