Is there a way for me to email all of my Looker users?

Knowledge Drop

Last tested: Jan 23, 2018
 

Currently there is not a direct way to do this in Looker.

In the meantime, a workaround would be to use System Activity to get the list of all the users and their email addresses.


If we go to base url + /explore/system_activity/user we can see there is a view on the left called USER.
We can select the email field and also apply a filter on the Is Disabled = No
That will give us a list of the email addresses for all the current Looker users.

Another approach would be to use the API and the get_all_users() call to retrieve all the users and their email address, then from the result, exclude the ones where is_disabled is true.

Finally when you have a list of the users to email, it may be easier to create a group of these email addresses via your email provider, and then use that group in the scheduler to send out to this group of users.

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 06:17 PM
Updated by: