steampipe plugin install akeyless-community/akeyless

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_type
from
akeyless_target;

List all Targets created in the last 30 days

select
*
from
akeyless_target
where
creation_date >= CURRENT_TIMESTAMP - INTERVAL '30 days';

Schema for akeyless_target

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
access_datetimestamp with time zoneThe date when the target was last accessed.
access_request_statustextThe current status of access requests for this target.
attributesjsonbAdditional attributes associated with the target.
client_permissionsjsonbThe permissions assigned to clients for this target.
creation_datetimestamp with time zoneThe date when the target was created.
is_access_request_enabledbooleanIndicates if access requests are enabled for this target.
last_versionbigintThe last version number of the target configuration.
modification_datetimestamp with time zoneThe date when the target was last modified.
protection_key_nametextThe name of the protection key used for securing the target.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
target_nametextThe name of the target.
target_typetextThe type of the target (e.g., database, cloud platform, server).
with_customer_fragmentbooleanIndicates if the target includes a customer-specific fragment.