Knowledge Management

How to search in an index conditioned from the summary index.

Communicator

Hi. I have summary index_sum, which has 2 events, 2 attributes:

A1sum, A2sum
1590482539, 7722527
1591080961, 7722525

I have also index2, where a lot of time events are stored. The index time time is important. I want to search the max(A1sum) from indexsum and use this value to filter values from the index2.
something like this:
index2
| where _time>max(A1
sum)

can you help me, please, with this problem?

Labels (1)
0 Karma
1 Solution

Super Champion

I haven't tested but you can try return command like below-

index=index2  |search _time>[search index=index_sum |stats max(A1_sum) as max|return $max]

View solution in original post

Super Champion

I haven't tested but you can try return command like below-

index=index2  |search _time>[search index=index_sum |stats max(A1_sum) as max|return $max]

View solution in original post

Communicator

Hi 493669. Your answer/help is amazing. It works absolutely great. Thank you very much.

0 Karma

Super Champion

@spisiakmi I am converting my comment into answer. Please accept and upvote if it helps.

0 Karma