Reporting

how to use inputlookup in subsearch

mvaradarajam
Path Finder

Hi All,
i have search like this,

|savedsearch [search index=_internal |eval tnow6 = now() | convert ctime(tnow6) | eval s=substr(tnow6,15,15) |eval r=substr(s,0,2)|eval SwitcherValue2=case(r%2=1,"alert1",r%2=0,"alert2")|dedup SwitcherValue2|return $SwitcherValue2]|table _time * threshold|makecontinuous _time

here alert1 and alert2 are the saved searches,but i am facing problem sometimes splunk deamon not response.i thought due to index search taken long time so my search has timed out.

how to use inputlookup instead of index="_internal".

here my query every 1 minute my saved search has changed.

can u plz help me

0 Karma
1 Solution

somesoni2
Revered Legend

Try this:

 |savedsearch [| stats count | eval r=tonumber(strftime(now(),"%M"))|eval SwitcherValue2=case(r%2=1,"alert1",r%2=0,"alert2")|dedup SwitcherValue2|return $SwitcherValue2]|table _time * threshold|makecontinuous _time

View solution in original post

somesoni2
Revered Legend

Try this:

 |savedsearch [| stats count | eval r=tonumber(strftime(now(),"%M"))|eval SwitcherValue2=case(r%2=1,"alert1",r%2=0,"alert2")|dedup SwitcherValue2|return $SwitcherValue2]|table _time * threshold|makecontinuous _time

somesoni2
Revered Legend

Then it should be some other problem. Check the error logs in _internal index to what is the problem.

Reference post:http://answers.splunk.com/answers/50485/splunkd-daemon-is-not-responding-the-read-operation-timed-ou...

0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...