Table: aiven_project_user - Query Aiven Project Users using SQL
An Aiven Project User is a user that has been granted access to a specific project within the Aiven platform. This user has certain permissions and roles within the project, which can include managing services, viewing billing information, and modifying project settings. Each user is associated with an email address, which is used as their unique identifier within the project.
Table Usage Guide
The aiven_project_user
table provides insights into users within Aiven Projects. As a project manager or system administrator, explore user-specific details through this table, such as their email, access control rights, and associated metadata. Utilize it to uncover information about users, such as their permissions within a project, to ensure proper access control and security measures are in place.
Examples
Basic info
Explore which team members are associated with different projects in your organization. This can help in understanding the distribution of resources and roles within your projects.
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_user;
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_user;
List users of the turbot project
Explore which team members are part of the 'turbot' project. This can help in understanding the composition of the project team, including their roles and whether they are a billing contact.
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_userwhere project_name = 'turbot';
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_userwhere project_name = 'turbot';
List users with admin access in projects
Discover the segments that have users with administrative access in various projects. This is beneficial for understanding project control distribution and identifying potential security risks.
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_userwhere member_type = 'admin';
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_userwhere member_type = 'admin';
List users with no billing contact
Gain insights into the accounts where no billing contact has been assigned to the user. This is beneficial for identifying potential gaps in account management and ensuring all users have appropriate billing contacts.
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_userwhere not billing_contact;
select email, real_name, billing_contact, member_type, project_name, create_time, team_namefrom aiven_project_userwhere billing_contact = 0;
List users who are not part of any team
Explore which users are not associated with any team, enabling you to identify potential areas of resource reallocation or team restructuring. This is particularly useful in assessing the overall distribution of users within your project.
select email, real_name, billing_contact, member_type, project_name, create_timefrom aiven_project_userwhere team_name = '';
select email, real_name, billing_contact, member_type, project_name, create_timefrom aiven_project_userwhere team_name = '';
Schema for aiven_project_user
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
auth_methods | jsonb | List of user's required authentication methods. | |
billing_contact | boolean | Set for project's billing contacts. | |
create_time | timestamp with time zone | Timestamp in ISO 8601 format, always in UTC. | |
text | = | User email address. | |
member_type | text | Project member type. | |
project_name | text | = | The project name. |
real_name | text | User real name. | |
team_id | text | The team ID. | |
team_name | text | The team name. |
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)" -- aiven
You can pass the configuration to the command with the --config
argument:
steampipe_export_aiven --config '<your_config>' aiven_project_user