Hi @sarge338 , the solution is the same using the sync-time field instead _time, being in epochtime it's easier to manage. As I said you have only to define if you want the exact sync-time or a per...
See more...
Hi @sarge338 , the solution is the same using the sync-time field instead _time, being in epochtime it's easier to manage. As I said you have only to define if you want the exact sync-time or a period (e.g. 5 minutes) and what's the rule to apply filter. index=your_index host IN (M1, M2, M3)
| stats dc(host) AS host_count BY "time-sync"
| where host_count=3 if the timestamps must be exactly the same, if instead they must be similar (e.g. 5 minutes ranges), you could run: index=your_index host IN (M1, M2, M3)
| bin span=5m "time-sync"
| stats dc(host) AS host_count BY "time-sync"
| where host_count=3 If possible, don't use the minus char "-", but understand char "_", because Splunk read it as the minus operator, so yu have to use quotes. Ciao. Giuseppe