Hello Splunk colleagues! I'm trying to create a new correlation search that generates a notable event, and uses a field I generate for the title. The title field in the notable indicates I can us...
See more...
Hello Splunk colleagues! I'm trying to create a new correlation search that generates a notable event, and uses a field I generate for the title. The title field in the notable indicates I can use variable substitution, and I've verified that the field is being created for every event the correlation search generates. the field is called my_rule_title In the notable event, I am putting in $my_rule_title$ and when the notable is generated, the rule title on incident review literally says "$my_rule_title$" and not the contents of the field my_rule_title. what am I doing wrong to get the rule title in incident review to display the value of my_rule_title? the other variable substitutions I'm doing in the correlation search for $description$ and $urgency$ are working as expected, just not the title.
Hello, I have the below SPL where I am looking to fetch the user accounts that have not logged in for 30 days or more but I am not seeing any results, Can someone please help me with this query if e...
See more...
Hello, I have the below SPL where I am looking to fetch the user accounts that have not logged in for 30 days or more but I am not seeing any results, Can someone please help me with this query if everything is good. index=windows sourcetype=* EventCode=4624 | stats latest(_time) as lastLogon by Account_Name | eval days_since_last_logon = round((now() - lastLogon) / 86400, 0) | where days_since_last_logon > 30 | table Account_Name, days_since_last_logon Thanks in advance
Hi In the end, I used this however it was not clear to me why I did not need to reference the newly created X_Mr. I could go straight to MR source="trace_Marketing_Bench_31032016_17_cff762901d1eff0...
See more...
Hi In the end, I used this however it was not clear to me why I did not need to reference the newly created X_Mr. I could go straight to MR source="trace_Marketing_Bench_31032016_17_cff762901d1eff01766119738a9218e2*.jsonl" host="TEST2" index="murex_logs" sourcetype="Market_Risk_DT" "**strategy**" 920e1021406277a9
| spath resourceSpans{}.scopeSpans{}.spans{}.attributes{} output=attributes
| mvexpand attributes
| spath input=attributes
| eval X_{key}=coalesce('value.doubleValue', 'value.stringValue')
| stats values(X_*) as * by _time
| stats sum(mr_batch_load_cpu_time) as batch_load_cpu_time sum(mr_batch_load_time) as batch_load_time sum(mr_batch_compute_time) as mr_batch_compute_time sum(mr_batch_compute_cpu_time) as mr_batch_compute_cpu_time by mr_strategy This created the below table that I was looking to do What I don't understand is at this point I can only see the new fields X_mr I added in a "| stats values(X_*) as * by _time" and we are back to the original - I don't get that.
The StatusMsg field is being created on the fly, but it has to come from *somewhere*. The OP has a list of possible messages, but there is no indication of when each is used. <<some expression>> re...
See more...
The StatusMsg field is being created on the fly, but it has to come from *somewhere*. The OP has a list of possible messages, but there is no indication of when each is used. <<some expression>> refers to a Boolean check that decides when to set StatusMsg to a specific string. The expression probably will need to test the values of other fields (perhaps Host and/or ConnName). You know your data better than I do so I can't be more detailed than that.
Search for all your users then extract the CN using the rex. If you are trying the tighten your search criteria, here is the spec for searches https://datatracker.ietf.org/doc/html/rfc2254
StatusMsg is the field (on the fly field) that I want to be populated by the message so I'm not certain what you mean by <<some expression>> So that was why I thought maybe this would be an if the...
See more...
StatusMsg is the field (on the fly field) that I want to be populated by the message so I'm not certain what you mean by <<some expression>> So that was why I thought maybe this would be an if then type of query. If StatusMsg="some value" then put that in the table along with the other data. If not, then go to the next status message. So I would want: Action Host ConnName "Task through an uncaught..." lx....... CCNBU---- So should this be an if then search?
if this helps, this is how we currently list the members of a specific AD Group ldapsearch search="(&(objectClass=user)(memberOf=CN=Schema Admins,OU=groups,DC=domain,DC=xxx))"
Setup currently is LM, indexer, SH, and DS are all on the same host. I'm currently using Splunk Enterprise Version: 9.4. I get about 10 messages a second logged in the splunkd.log with the following...
See more...
Setup currently is LM, indexer, SH, and DS are all on the same host. I'm currently using Splunk Enterprise Version: 9.4. I get about 10 messages a second logged in the splunkd.log with the following error: ERROR BTree [1001653 IndexerTPoolWorker-3] - 0th child has invalid offset: indexsize=67942584 recordsize=166182200, (Internal)
ERROR BTreeCP [1001653 IndexerTPoolWorker-3] - addUpdate CheckValidException caught: BTree::Exception: Validation failed in checkpoint I have noticed the btree_index.dat and btree_records.dat in /opt/splunk/data/fishbucket/splunk_private_db are re-created every few seconds. From what I can tell, after they get get to a certain point, those files are copied into the corrupt directory and are deleted. It then starts all over. I have tried to shutdown splunk and copy snapshot files over, but when I restart splunk they are overwritten and we start the whole loop of files getting created and then copied to corrupt. I tried a repair on the data files with the following command: splunk cmd btprobe -d /opt/splunk/data/fishbucket/splunk_private_db -r which returned the following output no root in /opt/splunk/data/fishbucket/splunk_private_db/btree_index.dat with non-empty recordFile /opt/splunk/data/fishbucket/splunk_private_db/btree_records.dat
recovered key: 0xd3e9c1eb89bdbf3e | sptr=1207
Exception thrown: BTree::Exception: called debug on btree that isn't open! It is totally possible there is some corruption somewhere. We did have a filesystem issue a while back. I had to do a fsck and there were a few files that I removed. As far as data I can't seem to find out where the problem might be. In splunk search I appear to have incomplete data in the _internal index. I can't view licensing and Data Quality are empty and have no data. Do I have some corrupt data somewhere which is causing problems with my btree index data? How would I go about finding the cause of this problem?
Hi everyone! After upgrading to version 3.8.1, I got a bunch of errors: In the Security Content i get the following: app/Splunk_Security_Essentials/security_content 404 (Not Found)Understand th...
See more...
Hi everyone! After upgrading to version 3.8.1, I got a bunch of errors: In the Security Content i get the following: app/Splunk_Security_Essentials/security_content 404 (Not Found)Understand this errorAI
web-client-content-script.js:2 Uncaught (in promise) Error: Access to storage is not allowed from this context. On the Data Inventory page i get the following: Error! Received the following error: Description Message Error occurred while grabbing data_inventory_products Traceback (most recent call last):
File "/opt/splunk/etc/apps/Splunk_Security_Essentials/bin/generateShowcaseInfo.py", line 473, in handle
if row['stage'] in ['all-done', 'step-review', 'step-eventsize', 'step-volume', 'manualnodata']:
KeyError: 'stage' There are also a couple of apps: splunk_essentials_8_2 and splunk_essentials_9_0 are both enabled. Does anyone know how to fix this? Thanks!
Qualys logs are not flowing to Splunk. This is the error: TA-QualysCloudPlatform: 2025-02-13 00:00:49 PID=3604316 [MainThread] ERROR: No credentials found. Cannot continue. How to debug it. Note: ...
See more...
Qualys logs are not flowing to Splunk. This is the error: TA-QualysCloudPlatform: 2025-02-13 00:00:49 PID=3604316 [MainThread] ERROR: No credentials found. Cannot continue. How to debug it. Note: We recently updated the expired credentials of Splunk user account in qualys,new credentials are working fine with the GUI (https://qualysguard.qg2.apps.qualys.com/fo/login.php). However, the Splunk add-on is still not accepting them, and logs are not flowing.
Update: Thanks for all the help. I was able to get an assist from a colleague and wanted to provide his search incase it works for anyone else. In a nutshell, the line rows=5, you can change t...
See more...
Update: Thanks for all the help. I was able to get an assist from a colleague and wanted to provide his search incase it works for anyone else. In a nutshell, the line rows=5, you can change to whatever number you need, but in the output if there are more than 5 hosts it will show you ... at the bottom so you know there is more, the columns on the right show you the initial amount of hosts and the amount if truncated | tstats values(host) as host where index=* by index
| foreach host ``` This code will only show you the first n values in the values() command```
[ eval rows=5
| eval mvCountInitial=mvcount('<<FIELD>>')
| eval <<FIELD>>=if(mvcount('<<FIELD>>')>$rows$, mvappend(mvindex('<<FIELD>>',0,$rows$-1),"..."), '<<FIELD>>')
| eval mvCountTruncated=if(mvcount('<<FIELD>>')>$rows$,mvcount('<<FIELD>>')-1,mvcount('<<FIELD>>'))
| fields - rows]
| rename mvCountInitial as "Total Host Count" mvCountTruncated as Truncated
Trying to build a search that will leverage ldapsearch to pull a current list of users that are members of a specific list of groups. For example some groups may be CN=Schema Admins,OU=groups,DC=...
See more...
Trying to build a search that will leverage ldapsearch to pull a current list of users that are members of a specific list of groups. For example some groups may be CN=Schema Admins,OU=groups,DC=domain,DC=xxx CN=Enterprise Admins,OU=group1,OU=groups,DC=domain,DC=xxx CN=Domain Admins Admins,OU=group1,OU=groups,DC=domain,DC=xxx This rex (?<=CN=)[^,]+ will grab the group name but having trouble pulling this all together This needs to search any group we want to include by specific name and then table out a list of the users that are members of each group sorted by the group name