Create an explore to follow active users that should be deactivated

[qchuchu]

Hi,

I have been playing around with the User Activity dashboard that shows the different users.

I would like to create a Data Quality dashboard, that based on my people data, I can receive alerts when a user has left the company but still has an active Looker Account.

I know how to create something using the user explore, but I would like to create a new explore that joins my people data.

Is it possible in my LookML declaration ? The other solution would be to load the looker data back into my warehouse using the API, but I'm wondering if there is something easier ! 

Thanks for your help !

[sam8]

This is such a cool use case! 

Unfortunately, there isn't a way to join the System Activity explores with any of your own explores in the LookML.

However, you can use merged results to join them! Might this help out in your use case?

[lindenPMP]

Following! The LookML dashboards and explores leave so much to be desired.