First all, thank you DalJeanis for responding back. And yes, lets remove the map verb please.
Question. In Line 2 you have 2 fields; ‘created’ and ‘request.created’. They are actually the same field. So when I coalesce I get no events.
NOTE: For clarity, the add_time is a timestamp (actually called timestamp) field shared by all events (i.e. add and remove). In the original second map I’m only interested in a) capturing the remove timestamp and b) carrying the other fields from the original search into the final map call. You are correct the fields you see at the bottom is from myindex2.
Sample data from myindex1 looks like this:
_time, “add”, timestamp, host1
_time, “remove”, timestamp, host1
_time, “add”, timestamp, host2
_time, “remove”, timestamp, host2
Sample data from myindex2 looks like this:
_time, src_user, src_user_name
The early and late time (add_time and the offset of add_time) gotten in the first search will be used to find the appropriate event in myindex2 by comparing its _time field.
In the end, after some renaming, it is this:
| table Account, Name, “Checked Out (_time_from myindex2)”, “Host Targeted”, “Add Time”, “Remove Time”
Please let me know if you have any questions. Thank you.
brdr
... View more