How to find the list of all users in Gitlab EE and their last used date via command?

How to Use GitLab
1

How to list out all users of Gitlab and their last used date via command? Please help

2 
echo "select name,last_sign_in_at from users" | gitlab-psql -d gitlabhq_production        
     name      | last_sign_in_at 
---------------+-----------------
 Administrator | 
(1 row)
1 Like
3

Hi,

next to the database command you could also write a small script which extracts the last_sign_in_at attribute from the received users via the REST API.

https://docs.gitlab.com/ee/api/users.html#for-admins

Cheers,
Michael