I have a macro which gets values including host,now i do a left join .Once i do a left join in the subsearch only those host which was in previous search result should be searched.
my search which results host
| join type=left xxx
[search index=a source=b host="host from previous search"]
Assume my first search returned many host,so in my second search after join,it should take individual host and check for any data in index=a
search1 |fields host| rename host as host1 | join host1 [search index=a source=b host="host from previous search"]
Thank you for your answer.
But my requirement is i should join based on some other value,but in the subsearch it should take host values from previous search(main search)