Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Filter query log by client hostname (including reverse resolved) #2191

Closed
dsheets opened this issue Oct 15, 2020 · 2 comments
Closed

Filter query log by client hostname (including reverse resolved) #2191

dsheets opened this issue Oct 15, 2020 · 2 comments
Labels
duplicate Duplicate or merged issues.

Comments

@dsheets
Copy link
Contributor

dsheets commented Oct 15, 2020

Problem Description

The machines on my network all have short, memorable, well-known names. I want to use these names to browse the query log but the query log filter only inspects literal fields of the json log entries.

Proposed Solution

Host names used as query log filters are checked through the known client directory and, if found, the resultant query is OR of existing functionality and client IP.

Alternatives Considered

  1. If resolution succeeds, ONLY the resolved IP is used for the filter.
  2. Logs extended to include resolved client host names.
  3. Support for logging to an external service like an ELK deployment.
@ameshkov
Copy link
Member

Looks like a duplicate of #1273

@dsheets
Copy link
Contributor Author

dsheets commented Oct 15, 2020

Indeed it is... I somehow missed that in my search. :-/

@dsheets dsheets closed this as completed Oct 15, 2020
@ameshkov ameshkov added the duplicate Duplicate or merged issues. label Oct 15, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
duplicate Duplicate or merged issues.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dsheets @ameshkov