Table: akeyless_target
Akeyless targets
Examples
List all Targets with complete information
select *from akeyless_target;
List all Targets by Name, Created Date, and Type
select target_name, creation_date, target_typefrom akeyless_target;
List all Targets created in the last 30 days
select *from akeyless_targetwhere creation_date >= CURRENT_TIMESTAMP - INTERVAL '30 days';
Schema for akeyless_target
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
access_date | timestamp with time zone | The date when the target was last accessed. | |
access_request_status | text | The current status of access requests for this target. | |
attributes | jsonb | Additional attributes associated with the target. | |
client_permissions | jsonb | The permissions assigned to clients for this target. | |
creation_date | timestamp with time zone | The date when the target was created. | |
is_access_request_enabled | boolean | Indicates if access requests are enabled for this target. | |
last_version | bigint | The last version number of the target configuration. | |
modification_date | timestamp with time zone | The date when the target was last modified. | |
protection_key_name | text | The name of the protection key used for securing the target. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
target_name | text | The name of the target. | |
target_type | text | The type of the target (e.g., database, cloud platform, server). | |
with_customer_fragment | boolean | Indicates if the target includes a customer-specific fragment. |