All Posts

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

All Posts

Please share some anonymised representative events in raw format in a code block </>
I am searching for "Unified Payment Platform Version=" which contains the specific version of firmware from about 2000+ hosts.  The line I am searching may populate multiple times depending on if th... See more...
I am searching for "Unified Payment Platform Version=" which contains the specific version of firmware from about 2000+ hosts.  The line I am searching may populate multiple times depending on if the device was rebooted. The search I need:  - list all the versions, but only one count from each host  - if possible, the list the hosts on the version
Thanks, this worked  
| eval TeamStart=mvindex(split(TeamWorkTimings,"-"),0) | eval TeamEnd=mvindex(split(TeamWorkTimings,"-"),1)
You could try something like this <your index search> | eventstats count by Version | eventstats max(count) as top | where count=top
The timechart command accepts only one field name in the by clause.  Anything else will result in an error.
Hi All, I have an output from a lookup table in splunk where the team work timings field is coming as:: TeamWorkTimings 09:00:00-18:00:00 I want the output to be separated in two fields, like: T... See more...
Hi All, I have an output from a lookup table in splunk where the team work timings field is coming as:: TeamWorkTimings 09:00:00-18:00:00 I want the output to be separated in two fields, like: TeamStart   TeamEnd 09:00:00       18:00:00   Please help me in getting this output in splunk
Hello, I've below dataset from Splunk search. Name percentage A 71% B 90% C 44% D 88% E 78%   All I need to change the percentage field values color as per below rule i... See more...
Hello, I've below dataset from Splunk search. Name percentage A 71% B 90% C 44% D 88% E 78%   All I need to change the percentage field values color as per below rule in the email alert. My requirement to achieve this by updating the sendemail.py. 95+ green, 80-94 amber, <80 = red @tscroggins @ITWhisperer @yuanliu @bowesmana 
Hi @KendallW ,   I reread you post and realized I didn't answer the Identity question.  I do not get an error when saving the identity.
Try something like this | eval {Function}_TIME=_time | stats values(Date_of_reception) as Date_of_reception values(*_TIME) as *_TIME by JOBNAME | eval Diff=ENDED_TIME-STARTED_TIME | fieldformat STAR... See more...
Try something like this | eval {Function}_TIME=_time | stats values(Date_of_reception) as Date_of_reception values(*_TIME) as *_TIME by JOBNAME | eval Diff=ENDED_TIME-STARTED_TIME | fieldformat STARTED_TIME=strftime(STARTED_TIME,"%H:%M:%S") | fieldformat ENDED_TIME=strftime(ENDED_TIME,"%H:%M:%S") | fieldformat PURGED_TIME=strftime(PURGED_TIME,"%H:%M:%S") | fieldformat Diff=tostring(Diff,"duration")
Please make sure you have entered correct username and password for an admin user on the remote search peer.
Hi, I am getting Axios 500 errors after installing the Salesforce Streaming API add-on app on my Splunk Cloud Trial (Classic). I can't configure the Inputs or Configuration tabs at all. I have a feel... See more...
Hi, I am getting Axios 500 errors after installing the Salesforce Streaming API add-on app on my Splunk Cloud Trial (Classic). I can't configure the Inputs or Configuration tabs at all. I have a feeling that this add-on isn't properly supported in the Trial Cloud instances. Has anyone had any luck getting this to work on Cloud Classic? Am I missing an additional configuration or app that I need to install to get this to work? Any help would be greatly appreciated. P.S.: I was able to get the Salesforce add-on to install, configure, and connect to my Sandbox just fine. It is this streaming api add-on that seems to be an issue. 
This give me the result in the below format.      is it possible to have 1 more field in the table and sort the columns in the below order: | JOBNAME | Date_of_reception | STARTED_TIME | EN... See more...
This give me the result in the below format.      is it possible to have 1 more field in the table and sort the columns in the below order: | JOBNAME | Date_of_reception | STARTED_TIME | ENDED_TIME | PURGED_TIME| Diff Between STARTED_TIME and ENDED_TIME |  | $VVF119P | 2024/04/17 | 02:12:37 | 02:12:46 | 02:12:50 | 00:00:09| 
I am trying to create a report that pulls a version, but only shows one instance and then list all the hosts within that version  
Take a look at this solution:   https://community.splunk.com/t5/Splunk-Search/Convert-Hexadecimal-IP-v4-addresses-to-decimal/td-p/40938 You could use:  (?<d1>\d{1,3})\.(?<d2>\d{1,3})\.(?<d3>\d{... See more...
Take a look at this solution:   https://community.splunk.com/t5/Splunk-Search/Convert-Hexadecimal-IP-v4-addresses-to-decimal/td-p/40938 You could use:  (?<d1>\d{1,3})\.(?<d2>\d{1,3})\.(?<d3>\d{1,3})\.(?<d4>\d{1,3}) for your particular example as the rex conversion. | makeresults count=1 | eval src_ip = "192.168.1.1" | streamstats values(src_ip) as src_ip by _time | rex field=src_ip "(?<d1>\d{1,3})\.(?<d2>\d{1,3})\.(?<d3>\d{1,3})\.(?<d4>\d{1,3})" | eval dec_src_ip = 'd1'*16777216+'d2'*65536+'d3'*256+'d4'+0 There is also an app that provides you a command to do the conversion:   https://splunkbase.splunk.com/app/512  
Try something like this index=events_prod_cdp_penalty_esa source="SYSLOG" sourcetype=zOS-SYSLOG-Console (TERM(VVF119P)) ("- ENDED" OR "- STARTED" OR "PURGED --") | rex field=TEXT "(VVF119P -)(?<Func... See more...
Try something like this index=events_prod_cdp_penalty_esa source="SYSLOG" sourcetype=zOS-SYSLOG-Console (TERM(VVF119P)) ("- ENDED" OR "- STARTED" OR "PURGED --") | rex field=TEXT "(VVF119P -)(?<Function>[^\-]+)" | fillnull Function value=" PURGED" | eval DAT = strftime(relative_time(_time, "+0h"), "%Y/%m/%d") | rename DAT as Date_of_reception | table JOBNAME,Date_of_reception ,Function , _time | sort _time | eval {Function}_TIME=strftime(_time,"%H:%M:%S") | stats values(Date_of_reception) as Date_of_reception values(*_TIME) as *_TIME by JOBNAME
I apologize for being vague.   Was just trying to stick to the point. The source (LogStash) cloud server is CentOS and we have zero access or control beyond the initial setup happening over the next... See more...
I apologize for being vague.   Was just trying to stick to the point. The source (LogStash) cloud server is CentOS and we have zero access or control beyond the initial setup happening over the next few days.  We are not permitted to install ANY software on this server as it is externally hosted and is locked down.  I plan to try and force the issue of a UF install, but I expect to be unsuccessful.  In which case, LogStash is all we have. My entire environment is 60-70 UF's to an on-prem Indexer.  I have no LogStash or HEC experience.  I have a bad feeling about this...
Hello My lookup table has fields of src_ip, dst_ip, and description. src_ip=192.168.1.1 dst_ip=192.168.1.100 description="internal IP" I want to convert the src_ip field and dst_ip to decimal.... See more...
Hello My lookup table has fields of src_ip, dst_ip, and description. src_ip=192.168.1.1 dst_ip=192.168.1.100 description="internal IP" I want to convert the src_ip field and dst_ip to decimal. If you know how to convert it, please add a reply.   Thank you
Hi  Can you please let me know how i can display the below 3 rows in a single row :   Query :  index=events_prod_cdp_penalty_esa source="SYSLOG" sourcetype=zOS-SYSLOG-Console (TERM(VVF119... See more...
Hi  Can you please let me know how i can display the below 3 rows in a single row :   Query :  index=events_prod_cdp_penalty_esa source="SYSLOG" sourcetype=zOS-SYSLOG-Console (TERM(VVF119P)) ("- ENDED" OR "- STARTED" OR "PURGED --") | rex field=TEXT "(VVF119P -)(?<Function>[^\-]+)" | fillnull Function value=" PURGED" | eval DAT = strftime(relative_time(_time, "+0h"), "%Y/%m/%d") | rename DAT as Date_of_reception | table JOBNAME,Date_of_reception ,Function , _time | sort _time   I want to display the result in the below format:  | JOBNAME | Date_of_reception | STARTED_TIME | ENDED_TIME | PURGED_TIME| | $VVF119P | 2024/04/17 | 02:12:37 | 02:12:46 | 02:12:50   Thanks in advance. 
Hi everyone, I have a line chart which works perfectly but only for one single value: index=events ComputerName=* Account_Name=*** EventCode=$event_code_input$ | | timechart count by EventCode ... See more...
Hi everyone, I have a line chart which works perfectly but only for one single value: index=events ComputerName=* Account_Name=*** EventCode=$event_code_input$ | | timechart count by EventCode As you can see it reads EventCode as a user input. This is a multi-selection box.  So if the user selects:  4624 it plots the line - no issue But if they select 4624 AND 4625, it produces an error.    I've tried many different variations and chart types but no success.  Thanks