Hi @ITWhisperer , I need your guidance for the below use case: - I need to fetch list of hosts present in lookup table and not fetched in the index, but with some conditions: - In lookup table, there are some hosts which have cluster and some which do not have cluster. Case 1: - Let us say at present index1 has 2 distinct IP address under field: host => 10.0.0.2, 10.0.0.4 When we search the values against the lookup table to fetch the list of missing hosts, we should get result as: -10.0.0.5 Logic: - 10.0.0.1, 10.0.0.2, 10.0.0.3 are belonging to same cluster in the lookup table. Thus, if any one of them gets fetched, we are fine. 10.0.0.4 does not have a cluster but it is present in the lookup table and also getting fetched. 10.0.0.5 is present in lookup table but not getting reported in the index, thus, it should be given as missing. Case 2: - Let us say at present index1 has 1 IP address under field: host => 10.0.0.5 When we search the values against the lookup table to fetch the list of missing hosts, we should get result as: -10.0.0.1, 10.0.0.2, 10.0.0.3, 10.0.0.4 Logic: - 10.0.0.1, 10.0.0.2, 10.0.0.3 are of the same cluster as per lookup table and none of them are getting reported in the index. 10.0.0.4 is present in the lookup table without a cluster but not getting fetched in the index. host cluster 10.0.0.1 A 10.0.0.2 A 10.0.0.3 A 10.0.0.4 10.0.0.5 Thank you
... View more