Can Please anyone help me in building the query for my alert so that It takes the index name and its corresponding threshold count from the above shred image of specified lookup table for threshold mapping without using Tstats command ? Sharing the screenshot of Static lookup file image below ?
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