As I understand your question, you want to get the counts of events in indexes, then be able to compare them to a threshold from a lookup file.
I created a sample lookup file "index_test.csv" with index_name and threshold.
The serach below adds the threshold value to the event data for each index count:
| tstats count where index=* by index
| lookup index_test.csv index_name AS index outputnew threshold
| eval busted_limit=if(count>threshold,"BUSTED","OK")
| table index,busted_limit,count,threshold
You can use whatever search you want in line 1 to get a count by index.
Line 2 maps (looks up) the lookup file field name (index_name) based on the search name (index) and adds (outputnew) the field threashold to the results
Line 3 compares the count to the threshold and sets a flag
Line 4 just displays the results
Hope this helps
... View more