index="dummy" url="https://www.dummy.com" status="200 OK"
| stats count by id
| where count > 10
If I apply this above query for 1 day, I would get this result, for example
id count
ABC 50
XYZ 60
This would mean ABC called `https://www.dummy.com` 50 times in 1 day, and XYZ called that 60 times.
Now I want to check this for 1 day but with every two hours interval
Suppose, ABC called that request 25 times at 12:00 AM, and then calls it 25 times at 3:AM, and XYZ called all the 60 requests between 12 AM and 2 AM
I want the output to look like this (time format doesn't matter)
id count time
XYZ 60 12:00 AM
ABC 25 12:00 AM
ABC 25 2:00 AM
Also, If I modify the query like this, count > 30, instead of count > 10, then it should only show the XYZ field, since ABC has 25 counts for both of them.
How do I modify my query?
... View more