THIS WORKS!!!!!!!!!! Thanks so much!!!! ... View more

Yeah it still doesn't mark the URLs in my list that don't exist in the index as 0. I'll just accept your solution though, thanks for your help 😃 ... View more

So my first SPL, it gets me the URLs I'm looking for but doesn't list the URLs (in the lookup) that don't get any results. So to break it down, say my csv has 120 URLs and I would like to know what my users are hitting and not hitting, when i run my first example search I'm getting 43 results back, but I also want to know what are the URLs (out of the 120) not hitting? Or should I create a search only telling me the URLs that don't match in the index? Whilst that example does make sense, in the stats table I get all these other URLs that aren't even in my lookup list that I care about.  So I go from expecting 120 results to (18,000). Does that make more sense? ... View more

That also returned every url not on my lookup.  I guess I could just take the hits and do a duplicate compare in excel but it'd be nice to see it all in splunk. Yeah, sorry about the tag I wasn't paying attention. ... View more