I have two indexes.
1- dns log with source IP with _time field
2 - dhcp log with dhcp IP with _time field
I figured out a way to match source IP of DNS Log and source IP of DHCP Log. However, what concerns me is the differences in time between these two indexes. Is there anyway to display the table as DNS_TIME, DHCP TIME (approximately 5m windows different), DHCP_hostname ???
I would really appreciate if anyone could help me with this!
Sounds like the transaction command with the maxspan option might be what you're after. Without sample logs, it's hard to tell, but something like:
| transaction IP maxspan=5m
might work.