topic Help in complex Search Query alert in Splunk Enterprise

Help in complex Search Query alert

Unige2021 — Mon, 31 May 2021 12:51:05 GMT

The context is Splunk is collecting data from a radar device.

Basically what it gets is the Latitude, Longitude and Id of nearby objects in a x meters radius range.

The events are in JSON format and the following is an exemple:

{ "Id": 1, "Latitude": x, "Longitude": y }

Splunk must trigger an alert when an object which previously was at position y, now is at position z iff delta z-y is too big.

I know the alert can be triggered if the search result returns at least 1 row, but I don't know how to write this query because too complex.

Is it possibile to make this query? How can I do this?
Thank you in advance!

Re: Help in complex Search Query alert

ITWhisperer — Mon, 31 May 2021 14:53:45 GMT

The JSON object only has 3 elements - of two events for the same id, how do you determine which was the previous. Given two events for the same id, how do you determine the diff between two events especially since these look like locations on a sphere?

Re: Help in complex Search Query alert

Unige2021 — Mon, 31 May 2021 15:58:11 GMT

Sorry you are right, I forgot to specify the JSON includes the timestamp too.