Hi! Is there a way to append the device owners email address to the live query CSV export? Currently I'm only getting the

device_owner

column

if you are using open source kolide there is a table, kolide_email_address I believe and you could do some kind of join or union on your queries to have that returned as well. Otherwise maybe as a decorator? I have not tried that

We're on the hosted version

ah, then nevermind. I have no experience

Aha! Looks like you are right anyway. There's indeed a

kolide_email_addresses

table.

great!

Now, I just need to join them together. What's the common key I wonder 🤔

yeah… I haven’t tried that 😕

Well, that was easy. Just add it to the list of select tables, i.e

SELECT * FROM system_info,kolide_email_addresses

ah there you go

Good point. That might explain what I'm looking at right now 🙂

Hi Martin, for questions regarding our hosted service, please email support@kolide.com. We’ll be able to see and respond to your questions much faster this way.

If you’re using the K2, there should be an intercom chat link in the bottom right corner. Feel free to reach us that way as well

also, Jason W's suggestion was spot on it seems, thanks!

Alright. Thanks. My adblocker removed the chat icon, hence I didn't notice it 🙂