Hi , Sorry , I missed to mention if they are of same event or different. The answer is they are from different events. The standalone query with makeresults is working as expected. I used the mai...
See more...
Hi , Sorry , I missed to mention if they are of same event or different. The answer is they are from different events. The standalone query with makeresults is working as expected. I used the main part of your query with mvmap and tweaked it as below : index=product_db time="1706589466.725491" | eval data1=if(match(time,"1706589466.725491"),_raw,0)| eval p_name_1=json_array_to_mv(json_keys(data1))|table p_name_1 |appendcols [ search index=product_db time="1705566003.777518" |eval data2=if(match(time,"1705566003.777518"),_raw,0) | eval p_name_2=json_array_to_mv(json_keys(data2)) ] | eval p_unique = mvmap(p_name_1, if(isnull(mvfind(p_name_2, "^".p_name_1."$")), p_name_1, null())) | eval p_missing = mvmap(p_name_2, if(isnull(mvfind(p_name_1, "^".p_name_2."$")), p_name_2, null())) | table p_unique p_missing Please let me know if you have any better suggestion to write this query. Thanks