theapsgroup/gitlab

steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_user

Obtaining information about Users on the GitLab instance.

Note: When used with the Public GitLab you must specify an = qualifier for at least one of the following fields.

  • id
  • username

This is to prevent attempting to return ALL users which would result in an error.

Examples

List all users

select
*
from
gitlab_user;

Obtain a list of usernames that are currently blocked

select
username,
state
from
gitlab_user
where
state = 'blocked';

Obtain a list of GitLab admins

select
username,
name,
state,
email
from
gitlab_user
where
is_admin = true;

.inspect gitlab_user

GitLab users and relevant information

NameTypeDescription
avatar_urltextThe url of the users avatar.
biotextThe biography of the user.
can_create_groupbooleanThe user has permissions to create groups.
can_create_projectbooleanThe user has permissions to create projects
color_scheme_idbigintThe ID of the users chosen color scheme.
confirmed_attimestamp without time zoneThe timestamp of user confirmation.
created_attimestamp without time zoneThe timestamp when the user was created.
current_sign_in_attimestamp without time zoneThe timestamp of users current signed in session.
custom_attributesjsonbJSON Array of custom attributes held against the user.
emailtextThe primary email address of the user.
ext_idtextThe external ID of the user.
externalbooleanIs the user an external entity
extra_shared_runners_minutes_limitbigintLimit in minutes of extra time the user can utilise shared runner resources.
idbigintThe ID of the user.
identitiesjsonbJSON Array of identity information for federated/IdP accounts
is_adminbooleanIs the user an Administrator
last_activity_ontimestamp without time zoneThe date user was last active.
last_sign_in_attimestamp without time zoneThe timestamp of users last sign in.
linkedintextThe LinkedIn account of the user.
locationtextThe geographic location of the user.
nametextThe name of the user.
notetextThe notes against the user.
organizationtextThe organization of the user.
private_profilebooleanIs the users profile set to private.
projects_limitbigintThe limit of personal projects the user can create.
providertextThe external provider of the user.
public_emailtextThe public email address of the user.
shared_runners_minutes_limitbigintLimit in minutes of time the user can utilise shared runner resources.
skypetextThe Skype address of the user.
statetextThe state of the user active, blocked, etc
theme_idbigintThe ID of the users chosen theme.
twittertextThe Twitter handle of the user.
two_factor_enabledbooleanHas the user enabled 2FA/MFA
usernametextThe login/username of the user.
using_license_seatbooleanIs the user utilising a seat/slot on the license.
web_urltextThe url for GitLab profile of user
website_urltextThe personal website of the user.