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.

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

Enhancement: More details for aggregated ECL searches #147

Open
sts opened this issue Oct 11, 2017 · 2 comments
Open

Enhancement: More details for aggregated ECL searches #147

sts opened this issue Oct 11, 2017 · 2 comments
Assignees

Comments

@sts
Copy link

sts commented Oct 11, 2017

When creating an ECL query in a alert search and making use of the aggregation filter, it will only display the aggregated field and the document count.

It would still be great to get some kind of reference to the original source documents and/or have the aggregation also append to chosen fields.

So given the following search:

es:applog event:login_error | agg:terms username | filter `_['count'] > 5` ;

Currently it returns:

┌─────────────────────────────────┬──────────┬────────┐
│ Time                            │ username │ count  │
│ Wed, 11 Oct 2017 09:13:30+00:00 │ mik      │     99 │
└─────────────────────────────────┴──────────┴────────┘

What would be great if it could return something like this:

┌─────────────────────────────────┬──────────┬───────────────────────┬───────┐
│ Time                            │ username │ ips                   │ count │
│ Wed, 11 Oct 2017 09:13:30+00:00 │ mik      │ 1.2.3.4, 4.3.2.1, ... │    99 │
└─────────────────────────────────┴──────────┴───────────────────────┴───────┘

What would also be great, to get clickable links to each ES document by clicking on eg. the ip address of an entry or a link to a search which returns the same results in Kibana.

@kiwiz kiwiz self-assigned this Oct 14, 2017
@kiwiz
Copy link
Contributor

kiwiz commented Oct 18, 2017

Hey there! This is a good idea, but I think it'll require some infra changes. #154 and #153 are prereqs to getting this in.

@kiwiz
Copy link
Contributor

kiwiz commented Oct 30, 2017

@sts In the example you provided, where does IP address come from? Is it just a field in the documents being aggregated? You might be able to do this with agg:top_hits right now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants