Hello, Example I have 2 lookups, first.csv and second.csv first.csv have 1 column name=fruit_name and with multivalue first.csv fruit_name apple banana melon mango grapes guyabano coconut second.csv have 2 column fruits and remarks with multivalue under fruits column fruits remarks apple mango guyabano visible How can i check if all the values of second.csv (apple,mango,guyabano) are present in the column fruit_name under first.csv then echo out the remarks with the value of visible Thanks in advance ... View more

  index=test | table severity location vehicle severity  location vehicle high Pluto Bike   testLookup.csv severity location vehicle high octane Pluto is one of the planet Bike has 2 wheels   As you can see on my table i have events. Is there a way to compare my table events to my testLookup.csv field values without using lookup command or join command ? Example. if my table events severity value have matched or has word same as "high" inside the severity in lookup field severity value then it is true otherwise false. Thank you. ... View more

Splunk Version: 8 OS: Windows Server Good afternoon. Maybe someone here may give me an idea how to troubleshoot. Customer update the OS of Windows server, then after the OS update the Splunk is unable to run the service. WARNING: Seems web interface is not to be available. No logs written in splunkd.log The folder or directory of Splunk is under Splunk user. Thank you. ... View more

Hi Good morning. We have a SH cluster and Indexer cluster. we have received a complain from SOC analyst some of notable events already exists(example last month or a week ago) are missing now or no longer visible on incedent review tab. But, when we try to run again the SPL on that day we got the result. When we try to search the `notable` | search event_id = "the event id of notable" no result found. NOTE: -The storage is big. -Some complain notable events present last week or last month are no longer visible now or they cannot search, but when we try to run the SPL on that day we got the result. Can someone guide me, what are the things need to check to pinpoint the cause of this concern we have now. I am new in splunk. ... View more

I have a SPL, when first running the result is appearing but once the query is finished the error have shown below: | tstats `summariesonly` count(All_Traffic.dest_ip) as destination_ip_count, count(All_Traffic.src_ip) as source_ip_count, count(All_Traffic.dest_port) as destination_port_count, count(All_Traffic.src_port) as source_port_count from datamodel=Network_Traffic.All_Traffic by All_Traffic.src_ip, All_Traffic.src_port, All_Traffic.dest_ip, All_Traffic.protocol, All_Traffic.src_zone, All_Traffic.protocol_version, All_Traffic.action, _time | lookup 3rd_party_network_connections_vendor_ip.csv index_ip as All_Traffic.src_ip OUTPUT value_ip | where isnotnull(value_ip) AND All_Traffic.src_port !="53" AND (All_Traffic.action="blocked" OR All_Traffic.action="denied" OR All_Traffic.action="failed") AND source_ip_count > 40 AND destination_ip_count > 40 ----------------------- The error StatsFileWriterLz4 file open failed file=C:\Splunk\var\run\splunk\srtemp\910252184_17768_at_1638875294.1\statstmp_merged_5.sb.lz4   ------------- May you validate if my SPL query is correct or not? Thanks     ... View more