Hi, I have set up my Elk stack and everything seems to be working perfectly in terms of indexing and filtering data that i require.
My log file contains the following :
123 20126254 6718 Chicken 1234 20326254 6718 Bread 123 20126254 6718 Chicken 123 20126254 6718 Chicken 12345 20426254 6718 Rice 123456 20526254 6718 apples 123 20126254 6718 Chicken
When i filter the results with grok i get the following output for each line in my log file:
OrderNumber : 123 ProductId: 20126254 ProductType: 6718 ProductName: Chicken
I need some advice on how to go about querying this data in elastic search in order to get specific results.
This is what i would like to do:
Select all OrderNumbers that contain the same productId
Please advise me on how i should go about doing this?
Should i use json?