https://community.splunk.com/t5/Splunk-Search/Comparing-diffing-2-lookup-tables/m-p/560532#M159294 <P>Hello,</P><P>I have 2 CSV lookups updating several times a day.&nbsp; One (A) is from CMDB with the entire list of assets (hostname, ip, user, os, etc).&nbsp; The other (B) is a list of installed clients for some product, also containing the hostname.&nbsp; I would like to get a search/dashboard that lists hosts in A that are not found in B with some of&nbsp; additional fields.&nbsp; Have no found a way to do with with 2 lookups, any ideas?&nbsp; Thanks!</P><P>Lookup CSV A: Host1, Host2, Host3<BR />Lookup CSV B: Host1, Host3<BR /><SPAN>Search output: Host2</SPAN></P><P>&nbsp;</P> Thu, 22 Jul 2021 21:28:18 GMT oleg106 2021-07-22T21:28:18Z https://community.splunk.com/t5/Splunk-Search/Comparing-diffing-2-lookup-tables/m-p/560532#M159294 <P>Hello,</P><P>I have 2 CSV lookups updating several times a day.&nbsp; One (A) is from CMDB with the entire list of assets (hostname, ip, user, os, etc).&nbsp; The other (B) is a list of installed clients for some product, also containing the hostname.&nbsp; I would like to get a search/dashboard that lists hosts in A that are not found in B with some of&nbsp; additional fields.&nbsp; Have no found a way to do with with 2 lookups, any ideas?&nbsp; Thanks!</P><P>Lookup CSV A: Host1, Host2, Host3<BR />Lookup CSV B: Host1, Host3<BR /><SPAN>Search output: Host2</SPAN></P><P>&nbsp;</P> Thu, 22 Jul 2021 21:28:18 GMT https://community.splunk.com/t5/Splunk-Search/Comparing-diffing-2-lookup-tables/m-p/560532#M159294 oleg106 2021-07-22T21:28:18Z https://community.splunk.com/t5/Splunk-Search/Comparing-diffing-2-lookup-tables/m-p/566991#M197589 <P>I am also looking for this same information. Anyone have an answer for this?</P> Tue, 14 Sep 2021 15:51:36 GMT https://community.splunk.com/t5/Splunk-Search/Comparing-diffing-2-lookup-tables/m-p/566991#M197589 crlunde 2021-09-14T15:51:36Z