All Posts

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

All Posts

Hello, colleagues. I am using independent streamfwd as a service installed on Linux Ubuntu 22.04.05. Streamfwd gets settings from the stream app and gets the indexers list. Everything is ok, streamf... See more...
Hello, colleagues. I am using independent streamfwd as a service installed on Linux Ubuntu 22.04.05. Streamfwd gets settings from the stream app and gets the indexers list. Everything is ok, streamfwd balancing data between all indexers, but if I made a push from the master node to the indexers cluster, and the indexers are rebooting, data balancing breaks after that streamfwd sending data just to one indexer. I can't find how to fix this. Please help thanks
Did you resolve this issue @gazoscreek ? I have same problem when upgrade from 9.2 to 9.4 currently.
Hi Rich, since i am breaking them into separate columns - i used this using if condition | eval TwoXXonly=if(status_code>=200 and status_code <300,1,0) | eval FourXXonly=if(status_code>=400 and s... See more...
Hi Rich, since i am breaking them into separate columns - i used this using if condition | eval TwoXXonly=if(status_code>=200 and status_code <300,1,0) | eval FourXXonly=if(status_code>=400 and status_code <500,1,0) | eval FiveXXonly=if(status_code>=500 and status_code <600,1,0) | stats sum(TwoXXonly) as Total_2xx, sum(FourXXonly) as Total_4xx,sum(FiveXXonly) as Total_5xx by date_only, org,cId,pPath, apie,apiPct,envnt | table list of fieds say for ex; in my data today i dont have 300 events but if they show up tomorrow - do i need to explicitly filter them out as i dont need them at all  - i have not used the status_code in by clause just confused - should i use the filter to explicitly exclude 300 ?
Hello, Hereby a new update on this case Some weeks ago we have upgraded Splunk to 941. After the upgrade we receive erros when executing Splunk commands like splunk show .. or btool Failed to c... See more...
Hello, Hereby a new update on this case Some weeks ago we have upgraded Splunk to 941. After the upgrade we receive erros when executing Splunk commands like splunk show .. or btool Failed to calculate cpu count from cgroup location="V2:/sys/fs/cgroup:/user.slice/user-570057916.slice/session-9.scope:/sys/fs/cgroup:/user.slice/user-570057916.slice/session-9.scope:" Because the Splunk version 941 added support for cgroups V2, we removed the workaround. Since then the original issue is back: adhoc hanging of systemctl If anyone has the issue, i really would like to know. Regards, Harry
I'd use a separate field that contains the status codes of interest.  Something like this | eval status=case(status_code<300 OR status_code>=400, status_code) ``` Other values of status_code set sta... See more...
I'd use a separate field that contains the status codes of interest.  Something like this | eval status=case(status_code<300 OR status_code>=400, status_code) ``` Other values of status_code set status to null``` | stats count by status
Hello @mbjerkeland_spl  Indeed Azure/Microsoft suggests to make use of Virtual Network Flow Logs, as the NSG Flow Logs will soon be deprecated.  We have trouble in extracting fields from the Vi... See more...
Hello @mbjerkeland_spl  Indeed Azure/Microsoft suggests to make use of Virtual Network Flow Logs, as the NSG Flow Logs will soon be deprecated.  We have trouble in extracting fields from the Virtual Network Flow Logs. We tried with props.conf and transforms.conf but no chance to get the fields correctly (for example, only the first source IP is extracted, i.e., src_ip = 50.110.12.0) Is there any way to get the fields correctly? [mscs:vnet:flow] LINE_BREAKER = \}([\r\n]s*,[\r\n]s*){ SEDCMD-remove_header = s/\{\s*\"records\"\:s*\[\s*//g SEDCMD-remove_footer = s/\][\r\n]\s*\}.*//g SHOULD_LINEMERGE = false KV_MODE = json TIME_PREFIX = time\":\" REPORT-tuples = extract_tuple [extract_tuple] FIELDS = time,src_ip,dst_ip,src_port,dst_port,protocol,traffic_flow,traffic_result,traffic_encryption,packets_out,bytes_out,packets_in,bytes_in MV_ADD = 1 SOURCE_KEY = flowRecords.flows{}.flowGroups{}.flowTuples{} Example of log: {"time":"2025-05-28T13:58:52.3816960Z","flowLogGUID":"78er54d6-9e30-493e-84c535-0dae4835a3c3","macAddress":"6044FDGB513","category":"FlowLogFlowEvent","flowLogResourceID":"/SUBSCRIPTIONS/ABC-CDE-EFG-GHI-23XCCX/RESOURCEGROUPS/MYRG/PROVIDERS/MICROSOFT.NETWORK/NETWORKWATCHERS/NETWORKWATCHER_MYREGION/FLOWLOGS/FLOWLOGNAME","targetResourceID":"/subscriptions/fdsfdsf-5534-42449-ddfds33-9718c766ed3f/resourceGroups/rggroup/providers/Microsoft.Network/virtualNetworks/vnet","flowLogVersion":4,"operationName":"FlowLogFlowEvent","flowRecords":{"flows":[{"aclID":"00000000-0000-0000-0000-000000000000","flowGroups":[{"rule":"PlatformRule","flowTuples":["1748440682030,50.110.12.0,10.0.0.1,23456,28701,6,I,B,NX,0,0,0,0"]}]},{"aclID":"fdf34-ff40-4bd1-9803-fdsfd54345","flowGroups":[{"rule":"DefaultRule_AllowInternetOutBound","flowTuples":["1748440669062,10.0.0.1,43.156.12.150,47212,443,6,O,C,NX,15,9521,11,7741","1748440672094,10.0.0.1,43.245.25.152,46512,443,6,O,E,NX,12,2377,10,8287"]}]}]}}
Thank you Rick, exactly what i was looking for..  can i give you another scenario - just guide please i have a field in the same index i dont have to show it in the table but i have to use a case st... See more...
Thank you Rick, exactly what i was looking for..  can i give you another scenario - just guide please i have a field in the same index i dont have to show it in the table but i have to use a case statement to sum or count the number of transactions status_code this will have values like 200, 201, 300, 302, 400,401, 500,502 i only need the count of events for  all 200  all 400 all 500 only  (dont need the one for 300) trying to get this into case statement
You can use the strptime and strftime functions to do that. | eval date=strftime(strptime(<<someField>>, "%a %d %b %Y %H:%M:%S:%3N %Z"), "%m/%d/%Y") where <<someField>> is the name of the field con... See more...
You can use the strptime and strftime functions to do that. | eval date=strftime(strptime(<<someField>>, "%a %d %b %Y %H:%M:%S:%3N %Z"), "%m/%d/%Y") where <<someField>> is the name of the field containing the date value shown.  
Hi ,  I have this scenario where i am getting data from one of the index with 2 other specified filters like index=index_logs_App989 customer="*ABC*" org in ("Provider1","Provider2") i have one f... See more...
Hi ,  I have this scenario where i am getting data from one of the index with 2 other specified filters like index=index_logs_App989 customer="*ABC*" org in ("Provider1","Provider2") i have one filed with the date values as below Tue 27 May 2025 15:26:23:702 EDT  - from this i have to take out the time part and convert it into date like 05/27/2025  - so that i can use this to aggregate at the date or day only ... any guidance please      
Hello, colleagues. After upgrading Splunk Stream 8.1.5 stopped parsing bytes_in, bytes_out, packets_in, packets_out, they are always equal to zero...  { [-] app_tag: PANA-L7-PEN : xxxxxxxxxxxxx b... See more...
Hello, colleagues. After upgrading Splunk Stream 8.1.5 stopped parsing bytes_in, bytes_out, packets_in, packets_out, they are always equal to zero...  { [-] app_tag: PANA-L7-PEN : xxxxxxxxxxxxx bytes_in: 0 bytes_out: 0 dest_ip: x.x.x.x dest_port: xxx endtime: 2025-05-28T15:01:26Z event_name: netFlowData exporter_ip: x.x.x.x exporter_time: 2025-May-28 15:01:26 exporter_uptime: 3148584010 flow_end_reason: 3 flow_end_rel: 0 flow_start_rel: 0 fwd_status: xx input_snmpidx: xx netflow_elements: [ [+] ] netflow_version: 9 observation_domain_id: 1 output_snmpidx: xxx packets_in: 0 packets_out: 0 protoid: 6 selector_id: 0 seqnumber: 2278842767 src_ip: x.x.x.x src_port: 9997 timestamp: 2025-05-28T15:01:26Z tos: 0 } I am using an independent streamforwarder with streamfwd installed as a service on linux ubuntu 22.04.5 If I stop the service and replace the streamfwd file with the old version 8.1.3 and start the service again, everything is ok Anybody run into this?  Thanks!
I’m not sure if this helps, but changes made on the search head cluster captain do appear in the bundle under /opt/splunk/var/run.
It seems that you are not using {0} in your query input. Also can you post the sanitized code for the code block and the full entry for the data path of the 0 input?
As the error message describes, you are trying to delete a playbook from a read-only repository. If you are importing it directly from the Splunk security content github repo, then you cannot delete ... See more...
As the error message describes, you are trying to delete a playbook from a read-only repository. If you are importing it directly from the Splunk security content github repo, then you cannot delete the playbook and would be better off removing the repo in your Source Control settings. If it is cloned to a repo you control, then you need to uncheck the "read only" setting for that repo.
Hello @gcusello , If you mean with multiple values from Lookup, I didnt tried. I would like to check the time from lookup with index timestamp events of deviation +0.5Sec or -0.5Sec from the ti... See more...
Hello @gcusello , If you mean with multiple values from Lookup, I didnt tried. I would like to check the time from lookup with index timestamp events of deviation +0.5Sec or -0.5Sec from the time in index and i need to show the result. Please let me know if there are any other way to do it. Thanks!
Hi @smanojkumar , without the static value, does it run? Ciao. Giuseppe
Hi @thanh_on , you can know this viewing the license consuption for each day, that's the total indexeing volume of all the day in all the Indexers of the Cluster. Ciao. Giuseppe
We had the same issue after an update, but the solution resolved it. Thank you!
Hello @gcusello , I was just testing with single value, Obviously it will be dynamic. Thanks again!
Hi @thanh_on  The "Daily Data Volume" in this case is the amount of daily ingest.  You can get this by going to https://yourSplunkInstance/en-US/manager/system/licensing Or by running the followin... See more...
Hi @thanh_on  The "Daily Data Volume" in this case is the amount of daily ingest.  You can get this by going to https://yourSplunkInstance/en-US/manager/system/licensing Or by running the following search: index=_internal [ rest splunk_server=local /services/server/info | return host] source=*license_usage.log* type="RolloverSummary" earliest=-30d@d | eval _time=_time - 43200 | bin _time span=1d | stats latest(b) AS b by slave, pool, _time | timechart span=1d sum(b) AS "volume" fixedrange=false | fields - _timediff | foreach "*" [ eval <<FIELD>>=round('<<FIELD>>'/1024/1024/1024, 3)]  Did this answer help you? If so, please consider: Adding karma to show it was useful Marking it as the solution if it resolved your issue Commenting if you need any clarification Your feedback encourages the volunteers in this community to continue contributing
Okay @mchoudhary - this might look a little bizarre but stay with me....you could use the following table output, this uses a search to determine the months returned based on the earliest/latest set ... See more...
Okay @mchoudhary - this might look a little bizarre but stay with me....you could use the following table output, this uses a search to determine the months returned based on the earliest/latest set by the time picker and lists them out as per the screenshot below. Would this work for you? | table Source [| makeresults count=12 | streamstats count as month_offset | addinfo | eval start_epoch=info_min_time, end_epoch=info_max_time | eval start_month=strftime(start_epoch, "%Y-%m-01") | eval month_epoch = relative_time(strptime(start_month, "%Y-%m-%d"), "+" . (month_offset-1) . "mon") | where month_epoch <= end_epoch | eval month=strftime(month_epoch, "%b") | stats list(month) as search ]     |tstats count where index=main by _time span=1d | eval MonthNum=strftime(_time, "%Y-%m"), MonthName=strftime(_time, "%b") | eval Source="Email" | eval Blocked=count | stats sum(Blocked) as Blocked by Source MonthNum MonthName | xyseries Source MonthName Blocked | addinfo | table Source [| makeresults count=60 | streamstats count as month_offset | addinfo | eval start_epoch=info_min_time, end_epoch=info_max_time | eval start_month=strftime(start_epoch, "%Y-%m-01") | eval month_epoch = relative_time(strptime(start_month, "%Y-%m-%d"), "+" . (month_offset-1) . "mon") | where month_epoch <= end_epoch | eval month=strftime(month_epoch, "%b") | stats list(month) as search ]  Did this answer help you? If so, please consider: Adding karma to show it was useful Marking it as the solution if it resolved your issue Commenting if you need any clarification Your feedback encourages the volunteers in this community to continue contributing