All Posts

Find Answers
Ask questions. Get answers. Find technical product solutions from passionate members of the Splunk community.

All Posts

The only thing that could work (but I haven't done this myself) is to use ingest actions. You'd need to use ingest actions to rewrite index on already parsed data. But the caveat is that I'm not sure... See more...
The only thing that could work (but I haven't done this myself) is to use ingest actions. You'd need to use ingest actions to rewrite index on already parsed data. But the caveat is that I'm not sure if you can do it as a "default" action or if you have to define it per every sourcetype separately.
Thanks , I am able to get error count now , could you please let me know how to get this value in python code .if I run the code I am getting events instead of statistics , How to get statitics in th... See more...
Thanks , I am able to get error count now , could you please let me know how to get this value in python code .if I run the code I am getting events instead of statistics , How to get statitics in the code  payload=f'search index="prod_k8s_onprem_vvvb_nnnn" "k8s.namespace.name"="apl-siii-iiiii" "k8s.container.name"="uuuu-dss-prog" NOT k8s.container.name=istio-proxy NOT log.level IN(DEBUG,INFO) (error OR exception)(earliest="07/25/2024:11:30:00" latest="07/25/2024:12:30:00")\n' '| addinfo\n' '| bin _time span=5m@m\n' '| stats count(eval(log.level="ERROR")) as error_count by _time\n' '| eventstats stdev(error_count)' print(payload) payload_escaped = f'search={urllib.parse.quote(payload)}' headers = { 'Authorization': f'Bearer {splunk_token}', 'Content-Type': 'application/x-www-form-urlencoded' } url = f'https://{splunk_host}:{splunk_port}/services/search/jobs/export?output_mode=json' response = requests.request("POST", url, headers=headers, data=payload_escaped, verify=False) print(f'{response.status_code=}') txt = response.text if response.status_code==200: json_txt = f'[\n{txt}]' os.makedirs('data', exist_ok=True) with open("data/output_deploy.json", "w") as f: f.write(json_txt) f.close() else: print(txt)
If you want to have your array from the "queue_mem_check" field ingested as separate events I'm afraid you'll have to preprocess it with an external tool before getting this data to Splunk.
Either I misunderstand something or you'd have your lookup "full" only for 1/4th of a day (or you're re-creating it whole in which case it's confusing why you want to have several copies of the same ... See more...
Either I misunderstand something or you'd have your lookup "full" only for 1/4th of a day (or you're re-creating it whole in which case it's confusing why you want to have several copies of the same data). What problem are you trying to solve?
Yeah, you're right. It was the other-way sawtooth. It looks strange. Are you sure you don't have any network-level issues? And don't you see any other interesting stuff in _internal (outside of the M... See more...
Yeah, you're right. It was the other-way sawtooth. It looks strange. Are you sure you don't have any network-level issues? And don't you see any other interesting stuff in _internal (outside of the Metrics component) for this forwarder?  
Just extract the content of "msg" into a new field, then apply spath   | rex "msg=(?<msg>.+)" | spath input=msg   Here is the output from your sample data meteoHumidity meteoRainlasthour me... See more...
Just extract the content of "msg" into a new field, then apply spath   | rex "msg=(?<msg>.+)" | spath input=msg   Here is the output from your sample data meteoHumidity meteoRainlasthour meteoTemp meteoWindDirection meteoWindSpeed meteolunaPercent msg 64 0 17.9 SW 6.04 67.3 {"meteoTemp":17.9,"meteoHumidity":64,"meteoRainlasthour":0,"meteoWindSpeed":6.04,"meteoWindDirection":"SW","meteolunarPercent":67.3} This is an emulation for you to play with and compare with real data.   | makeresults | eval _raw = "Fri Jul 26 15:24:46 BST 2024 name=mqtt_msg_received event_id= topic=meteobridge msg={\"meteoTemp\":17.9,\"meteoHumidity\":64,\"meteoRainlasthour\":0,\"meteoWindSpeed\":6.04,\"meteoWindDirection\":\"SW\",\"meteolunarPercent\":67.3}" ``` data emulation above ```    
Hi @Zer0F8th, you have to start from the main search, please try this: | tstats count WHERE index=* earliest=-7d BY host | append [ | inputlookup lookup.csv | eval count=0 | ... See more...
Hi @Zer0F8th, you have to start from the main search, please try this: | tstats count WHERE index=* earliest=-7d BY host | append [ | inputlookup lookup.csv | eval count=0 | fields FQDN count ] | append [ | inputlookup lookup.csv | eval count=0 | fields IP count ] | append [ | inputlookup lookup.csv | eval count=0 | fields Hostname count ] | eval host=coalesce(host, FQDN, IP, Hostname) | stats sum(count) AS total BY host | where total=0 Ciao. Giuseppe  
Hi, complete Splunk beginner here, so sorry it this is a stupid question. I'm trying to chart some data that I'm pulling from an MQTT broker. The Splunk  MQTT Modular Input app is doing its thing a... See more...
Hi, complete Splunk beginner here, so sorry it this is a stupid question. I'm trying to chart some data that I'm pulling from an MQTT broker. The Splunk  MQTT Modular Input app is doing its thing and data is arriving every 5 minutes. Using the most basic query  (  source="mqtt://MeteoMQTT"  ) gives these results:   Fri Jul 26 15:24:46 BST 2024 name=mqtt_msg_received event_id= topic=meteobridge msg={"meteoTemp":17.9,"meteoHumidity":64,"meteoRainlasthour":0,"meteoWindSpeed":6.04,"meteoWindDirection":"SW","meteolunarPercent":67.3}   What I really want to do though is to break out the values from the most recent data poll into separate "elements" that can then be added to a dashboard. I tried using the spath command: source="mqtt://MeteoMQTT" | spath output=meteoTemp path=meteoTemp But that just returned the whole object again. So, how can i parse out the different values (meteoTemp, meteoHumidity, meteoRainlasthour, etc), so that i can add their most recent values as individual dashboard elements please? TIA.
Hi All, So I have a lookup table with the following fields: FQDN, Hostname, and IP. I need to check to see which of these assets in the lookup table are logging (about 700 assets) and which aren't... See more...
Hi All, So I have a lookup table with the following fields: FQDN, Hostname, and IP. I need to check to see which of these assets in the lookup table are logging (about 700 assets) and which aren't in the last 7 days. I used the following basic SPL to get a list of hosts which are logging:   | tstats earliest(_time) latest(_time) count where index=* earliest=-7d by host   The issue I'm having is that the host output in the above SPL comes through in different formats, it may be a FQDN or a Hostname, or an IP address. How do I use my lookup table to check if the assets in the lookup table are logging without having to do 3 joins on FQDN, Hostname and IP? Here was a SPL query that somewhat worked but it is too inefficient:   | inputlookup lookup.csv | eval FQDN=lower(FQDN) | eval Hostname=lower(Hostname) | join type=left FQDN [ |tstats latest(_time) as lastTime where index=* earliest=-7d by host | rename host as FQDN | eval FQDN=lower(FQDN) | eval Days_Since_Last_Log = round((now() - lastTime) / 86400) | convert ctime(lastTime) ] | join type=left Hostname [ |tstats latest(_time) as lastTime where index=* earliest=-7d by host | rename host as Hostname | eval Hostname=lower(Hostname) | eval Days_Since_Last_Log = round((now() - lastTime) / 86400) | convert ctime(lastTime) ] | join type=left IP[ |tstats latest(_time) as lastTime where index=* earliest=-7d by host | rename host as IP | eval IP=lower(IP) | eval Days_Since_Last_Log = round((now() - lastTime) / 86400) | convert ctime(lastTime) ] | rename lastTime as LastTime | fillnull value="NULL" | table FQDN, Hostname, IP, Serial, LastTime, Days_Since_Last_Log   I'm somewhat new to Splunk so thank you for the help!
Hi @elend , if the Time in dashboardA is defined in a Time imput called e.g. "Time", so the tokens are a called $Time.earliest$ and $Time.latest$, you can pass then in the drilldown url: earliest=$... See more...
Hi @elend , if the Time in dashboardA is defined in a Time imput called e.g. "Time", so the tokens are a called $Time.earliest$ and $Time.latest$, you can pass then in the drilldown url: earliest=$Time.earliest$&amp;latest=$Time.latest$ Ciao. Giuseppe
So the premise is that I constructed two dashboards: dashboard A as an overview and dashboard B as details. Then, on dashboard A, I configured one of the displays to have an on-click trigger that con... See more...
So the premise is that I constructed two dashboards: dashboard A as an overview and dashboard B as details. Then, on dashboard A, I configured one of the displays to have an on-click trigger that connects to dashboard B. However, the global time condition on dashboard A cannot be connected to dashboard B.   is it possible to make the time dynamic on dashboard B?
Hi @ebd12 , you can use the same msi to install Splunk different times on different servers, not on the the same server. You cannot install two times on the same server. If you have a linux server... See more...
Hi @ebd12 , you can use the same msi to install Splunk different times on different servers, not on the the same server. You cannot install two times on the same server. If you have a linux server and completely remove the old installation, you can install again on the same server. If you have an error in the second installation, it could be related to a different issu. Ciao. Giuseppe
@ITWhisperer Thanks for your help and suggestion.
Wouldn't you think if I knew of another way I would have mentioned it? You can't use strings for values in charts.
Hello ,  Am I eligeable for an other 60days free trial splunk enterprise  with the same splunk email accompt  ? I tried to install splunk enterprise in an other PC ( with the same .msi  exec  used t... See more...
Hello ,  Am I eligeable for an other 60days free trial splunk enterprise  with the same splunk email accompt  ? I tried to install splunk enterprise in an other PC ( with the same .msi  exec  used the first time, then I  tried a new one ) but  the installation failed ( error  splunk enterprise wizard setup end prematurely) . My free trial  goes  until 11 August 2024 , I did'nt uninstall splunk enterprise on the first PC Im confuse, does any one can help me  
@ITWhisperer  Any alternative to showcase this in line chart ?    
My org has millions of events coming in through firewalls. I had a 24 hour timeframe search take 12.5 hours to run.  I was curious if I broke it up into 6 hour timeframes (changing the earliest/l... See more...
My org has millions of events coming in through firewalls. I had a 24 hour timeframe search take 12.5 hours to run.  I was curious if I broke it up into 6 hour timeframes (changing the earliest/latest statements accordingly), and having them outputlookup to the same lookup file. I would then inputlookup the file and tailor enrich accordingly, however I want to reset after each day. ie. I do not want the file to keep growing. Would I set append=false on query1, and append=true for query2, query3, and query4? 
| foreach Maximum Average Minimum [ eval <<FIELD>>_duration=tostring(<<FIELD>>,"duration") ] However, as I said before, you can't use these duration fields on a chart as they are strings not numbers
This looks like a perfectly reasonable event to ingest whole - you should specify that it is JSON format for extraction purposes, and you can use the json_* functions to manipulate the data in your s... See more...
This looks like a perfectly reasonable event to ingest whole - you should specify that it is JSON format for extraction purposes, and you can use the json_* functions to manipulate the data in your searches. Is it just that you need help to find the timestamp for the event or is Splunk already doing that correctly?
@ITWhisperer  index=wma_bext TYPE=FULFILLMENT_REQUEST STATUS="Marshalling" | eval completion_time=strptime(COMPLETED_TIMESTAMP, "%Y-%m-%dT%H:%M:%S.%3QZ") | stats count by completion_time FULFIL... See more...
@ITWhisperer  index=wma_bext TYPE=FULFILLMENT_REQUEST STATUS="Marshalling" | eval completion_time=strptime(COMPLETED_TIMESTAMP, "%Y-%m-%dT%H:%M:%S.%3QZ") | stats count by completion_time FULFILLMENT_START_TIMESTAMP _time | eval lead_time = (completion_time - FULFILLMENT_START_TIMESTAMP) | timechart max(lead_time) as "Maximum" avg(lead_time) as "Average" min(lead_time) as "Minimum" | foreach Maximum Average Minimum [ eval <<FIELD>>_hours=round('<<FIELD>>'/3600, 2), <<FIELD>>_minutes=round('<<FIELD>>'/60, 2) ] When I use above query to combine hours and minutes and again , then i used to write like this "| eval max_d = Maximum_hours. ":" .Maximum_minutes" and again it comes into a string mode. Please suggest me how I can showcase my results in HH:MM mode for maximum, average, minimum. Below results currently I am getting by using above query.