v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Hub

Plugins Mods Docs Home

Plugins

akeyless-community/akeyless

steampipe plugin install akeyless-community/akeylesssteampipe plugin install akeyless-community/akeyless

akeyless_auth_method akeyless_gateway akeyless_item akeyless_role akeyless_target

Table: akeyless_item

Akeyless items

Examples

List all Items with complete information

select
  *
from
  akeyless_item;

List all Items by Name and Type

select
  item_name,
  item_sub_type
from
  akeyless_item;

List all Items created in the last 30 days

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

Schema for akeyless_item

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access_request_status	text		The current status of access requests for the item.
account_id	text		The account identifier associated with the item.
auto_rotate	boolean		Indicates whether the item is set to rotate automatically.
client_permissions	jsonb		Permissions assigned to clients for this item.
creation_date	timestamp with time zone		The date and time when the item was created.
delete_protection	boolean		Indicates if delete protection is enabled for the item.
is_access_request_enabled	boolean		Indicates if access requests are enabled for this item.
is_enabled	boolean		Indicates if the item is currently enabled.
item_general_info	jsonb		General information about the item.
item_id	bigint		The unique identifier for the item.
item_name	text		The name of the item.
item_state	text		The current state of the item.
item_sub_type	text		The sub-type of the item.
item_targets_assoc	jsonb		Associations between the item and its targets.
last_rotation_date	timestamp with time zone		The date when the last rotation for the item occurred.
last_version	bigint		The most recent version number of the item.
modification_date	timestamp with time zone		The date and time when the item was last modified.
next_rotation_date	timestamp with time zone		The date when the next rotation for the item is scheduled.
protection_key_name	text		The name of the protection key used for securing the item.
rotation_interval	bigint		The interval at which the item is rotated.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
with_customer_fragment	boolean		Indicates if the item includes a customer-specific fragment.