How to see who/when created a user account?

Looker Q&A Looker
1

Is there a way to see logs of who and when a given user had their account created?

1 Like
2

Hi @schoolsofthough!

You can use the System Activity Explores to find this kind of information. The Event Attribute explore specifically has a wealth of information and you can find detailed documentation for it here.

For your specific question if you are using SAML/LDAP/OAuth to log users into the instance, user creation will sit more on the IdP side so you won’t be able to use this method. However, if you are using the classic email/password authentication to log users in you can use the below link to see when users were created and by which user. Just replace the the base URL with your instance URL. In this link, the Value of the Event Attribute user_id will be the user_id that was created and the ID field from the User drop down is the user_id of the user that had done the creation process.

URL for User Creation 
https://YOUR_LOOKER_INSTANCE_HERE/explore/system__activity/event_attribute?fields=event.created_time,event_attribute.value,user.id&f[event_attribute.name]=%22user_id%22&f[event.name]=%22create_user%22&sorts=event.created_time+desc&limit=500&column_limit=50&vis=%7B%22show_view_names%22%3Afalse%2C%22show_row_numbers%22%3Atrue%2C%22transpose%22%3Afalse%2C%22truncate_text%22%3Atrue%2C%22hide_totals%22%3Afalse%2C%22hide_row_totals%22%3Afalse%2C%22size_to_fit%22%3Atrue%2C%22table_theme%22%3A%22white%22%2C%22limit_displayed_rows%22%3Afalse%2C%22enable_conditional_formatting%22%3Afalse%2C%22header_text_alignment%22%3A%22left%22%2C%22header_font_size%22%3A12%2C%22rows_font_size%22%3A12%2C%22conditional_formatting_include_totals%22%3Afalse%2C%22conditional_formatting_include_nulls%22%3Afalse%2C%22type%22%3A%22looker_grid%22%2C%22defaults_version%22%3A1%7D&filter_config=%7B%22event_attribute.name%22%3A%5B%7B%22type%22%3A%22%3D%22%2C%22values%22%3A%5B%7B%22constant%22%3A%22user_id%22%7D%2C%7B%7D%5D%2C%22id%22%3A3%2C%22error%22%3Afalse%7D%5D%2C%22event.name%22%3A%5B%7B%22type%22%3A%22%3D%22%2C%22values%22%3A%5B%7B%22constant%22%3A%22create_user%22%7D%2C%7B%7D%5D%2C%22id%22%3A4%2C%22error%22%3Afalse%7D%5D%7D&origin=share-expanded
1 Like
3

hmm if we did use an OAuth Connection setup, user creation events wouldn’t show up in that Event Attribute Explore? Why is that?

4

Hi @schoolsofthough to clarify, the Event Attribute Explore does show user creation events. The only thing it will not show if you are using OAuth is who created the user since the person "creating” the user does so more in the IdP side as opposed to directly in Looker when using SAML/LDAP/OAuth.

1 Like
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.