https://github.com/osquery/osquery logo
#kolide
Title
# kolide
m

Martin Westergaard Lassen

02/11/2020, 11:53 AM
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
Never received any response on this question. Anyone?
j

Jason W

02/14/2020, 1:21 PM
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
m

Martin Westergaard Lassen

02/14/2020, 1:21 PM
We're on the hosted version
j

Jason W

02/14/2020, 1:21 PM
ah, then nevermind. I have no experience
m

Martin Westergaard Lassen

02/14/2020, 1:36 PM
Aha! Looks like you are right anyway. There's indeed a
kolide_email_addresses
table.
j

Jason W

02/14/2020, 1:37 PM
great!
m

Martin Westergaard Lassen

02/14/2020, 1:37 PM
Now, I just need to join them together. What's the common key I wonder 🤔
j

Jason W

02/14/2020, 1:38 PM
yeah… I haven’t tried that 😕
m

Martin Westergaard Lassen

02/14/2020, 1:52 PM
Well, that was easy. Just add it to the list of select tables, i.e
Copy code
SELECT * FROM system_info,kolide_email_addresses
j

Jason W

02/14/2020, 1:52 PM
ah there you go
it can return several, so you can probably use a where clause to contain to your company domain, etc.
m

Martin Westergaard Lassen

02/14/2020, 1:53 PM
Good point. That might explain what I'm looking at right now 🙂
a

Antigoni

02/14/2020, 2:33 PM
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.
s

seph

02/14/2020, 2:40 PM
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
b

blaedj

02/14/2020, 3:50 PM
also, Jason W's suggestion was spot on it seems, thanks!
m

Martin Westergaard Lassen

02/15/2020, 11:40 AM
Alright. Thanks. My adblocker removed the chat icon, hence I didn't notice it 🙂
2 Views