steampipe plugin install linode

Table: linode_user - Query Linode Users using SQL

Linode Users represent individual users within a Linode account. Each user can have different permissions and access levels, depending on their role within the account. Users can be granted either unrestricted access to all Linode resources or restricted access to only certain resources.

Table Usage Guide

The linode_user table provides insights into individual users within a Linode account. As a system administrator, explore user-specific details through this table, including their usernames, emails, and whether they have restricted access. Utilize it to manage user permissions and access levels, ensuring the security and integrity of your Linode resources.

Examples

List users

Explore the list of users to understand who has access to your system, a crucial step in ensuring data security and managing user permissions.

select
*
from
linode_user;
select
*
from
linode_user;

Schema for linode_user

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
emailtextThe email address for this User, for account management communications, and may be used for other communications as configured.
filtertext=Raw Linode list filter string in JSON format.
restrictedbooleanIf true, this User must be granted access to perform actions or access entities on this Account.
ssh_keysjsonbA list of SSH Key labels added by this User. These are the keys that will be deployed if this User is included in the authorized_users field of a create Linode, rebuild Linode, or create Disk request.
usernametext=This User’s username. This is used for logging in, and may also be displayed alongside actions the User performs (for example, in Events or public StackScripts).

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- linode

You can pass the configuration to the command with the --config argument:

steampipe_export_linode --config '<your_config>' linode_user