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_user_event
The gitlab_user_event table can be used to query information about user activity on a gitlab system.
Examples
List all issues worked on in the last week by user alice
select project.full_path, event.target_iid, event.action_namefrom gitlab_user_event as event, gitlab_project as project, gitlab_user as uwhere event.project_id = project.id and target_type = 'Issue' and event.created_at > current_date - interval '7 days' and event.author_id = u.id and u.username = 'alice';Get activity counts by project over the last 30 days by user bob
select project.full_path, count(project.full_path) as eventsfrom gitlab_user_event as event, gitlab_project as projectwhere event.project_id = project.id and event.created_at > current_date - interval '30 days' and event.author_id = u.id and u.username = 'bob'group by project.full_pathorder by events;Schema for gitlab_user_event
| Name | Type | Operators | Description |
|---|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
| action_name | text | = | The action this event tracks: approved, closed, commented on, created, destroyed, expired, joined, left, merged, pushed to, reopened, updated |
| author | jsonb | JSON struct describing the user | |
| author_id | bigint | = | The ID of the user who created the event |
| author_username | text | author_username | |
| created_at | timestamp with time zone | >, >=, =, <, <= | When the event was created |
| id | bigint | The event ID | |
| note | jsonb | JSON struct if there's a note | |
| project_id | bigint | The project ID | |
| push_data | jsonb | JSON struct if there's push data | |
| target_id | bigint | The target ID | |
| target_iid | bigint | The target IID | |
| target_title | text | The title of the target | |
| target_type | text | = | What the event was: issue, milestone, merge_request, note, project, snippet, user |