Hello, I am after some help to define the search that will display a list of field values if the value in another field changes from one value to another within a certain time frame
For example, I want to see the value of the field ID if the value of the field Loc changes from ABC to DEF within 30 minutes.
Thanks in advance.
My guess will be that You could try transaction command on the ID field. May be something like this
your base search | transaction ID maxspan=30m startswith=ID=ABC endswith=ID=DEF | table your fields
My guess will be that You could try transaction command on the ID field. May be something like this
your base search | transaction ID maxspan=30m startswith=ID=ABC endswith=ID=DEF | table your fields
Thanks. I made a small modification and that gave me exactly what I wanted. It showed all the locations (Loc) within the 30 minutes time window of the ID. Appreciated.
my search | transaction ID maxspan=30m startswith=Loc=ABC endswith=Loc=DEF | table ID Loc