Specifically, right now we are trying to audit que...
# kolide
t
Specifically, right now we are trying to audit queries run from the management UI or fleetctl. I see logging for the queries themselves, but these logs don't contain the user who initiated the query. Is that possible to add?
z
Usernames are logged for live queries in Fleet 2.5.0+ Example:
Copy code
level=info ts=2020-05-29T20:44:18.498455Z component=service method=NewDistributedQueryCampaign err=null user=admin sql="SELECT * FROM foobar" numHosts=8 took=46.944228ms
t
Ooooo. Shiny. Seems like this may have been a configuration issue on our end then. Thanks for the tip Zach.
z
Very shiny. Thanks to @TheHellaJeff for putting in that one 🙂
v
is this in the status.log , right?
z
This is in the Fleet server log.
v
yes, I mean status log file on fleet server
👍 1
s
FWIW, these are also recorded in the
queries
table in the database in versions previous to 2.5.0 if you need to pull that info