gitlab_applicationgitlab_branchgitlab_commitgitlab_epicgitlab_groupgitlab_group_access_requestgitlab_group_hookgitlab_group_iterationgitlab_group_membergitlab_group_projectgitlab_group_push_rulegitlab_group_subgroupgitlab_group_variablegitlab_hookgitlab_instance_variablegitlab_issuegitlab_merge_requestgitlab_merge_request_changegitlab_my_eventgitlab_my_issuegitlab_my_projectgitlab_projectgitlab_project_access_requestgitlab_project_container_registrygitlab_project_deploymentgitlab_project_iterationgitlab_project_jobgitlab_project_membergitlab_project_pages_domaingitlab_project_pipelinegitlab_project_pipeline_detailgitlab_project_protected_branchgitlab_project_repositorygitlab_project_repository_filegitlab_project_variablegitlab_settinggitlab_snippetgitlab_usergitlab_user_eventgitlab_version
Table: gitlab_project_member
A project member is a user that is associated to a specific project.
The gitlab_project_member
table can be used to query information members of a specific project.
However, you must specify a project_id
in the where or join clause.
Examples
List all members for a specific project
select *from gitlab_project_memberwhere project_id = 123;
Query examples
Schema for gitlab_project_member
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
access_desc | text | The descriptive of the access level held by the project member. | |
access_level | bigint | The access level the project member holds within the project. | |
avatar_url | text | The url of the project members avatar. | |
created_at | timestamp with time zone | Timestamp at which the user was created. | |
expires_at | timestamp with time zone | The date of expiration of access to the project. | |
id | bigint | The id of the project member - link to `gitlab_user.id` | |
name | text | The name of the project member. | |
project_id | bigint | = | The project id - link to gitlab_project.id`. |
state | text | The state of the project member active, blocked, etc | |
username | text | The username of the project member - link to `gitlab_user.username`. | |
web_url | text | The url for profile of the project member. |