All Posts

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

All Posts

I am trying to parse some data for API latency. I have a value for "elapsedTime" which spits that out. However if a request takes longer than 999ms, then it changes to reporting in seconds. So... the... See more...
I am trying to parse some data for API latency. I have a value for "elapsedTime" which spits that out. However if a request takes longer than 999ms, then it changes to reporting in seconds. So... the query below could return 999ms or 1.001s. What eval statement do I need here to parse the value of elapsedTime and if it contains "s" and not "ms",  then * 1000 to get a value in ms... | NEED SOME EVAL HERE I GUESS | stats min(elapsedTime) as Fastest max(elapsedTime) as Slowest avg(elapsedTime) as "Average"
I am looking to audit any user that uploads to splunk through the User interface or REST API  After doing some investigation I have found that the endpoints /services/app/local is the REST API endp... See more...
I am looking to audit any user that uploads to splunk through the User interface or REST API  After doing some investigation I have found that the endpoints /services/app/local is the REST API endpoint that can be used to post an application. I was wondering whether splunk internally posts to that API when you utilise the GUI so by auditing that log you can get both use cases.  I have crafted the below search to isolate these events and confirmation that this works would be awesome! index=_internal sourcetype=splunkd_access /services/apps/local method=POST Appreciate all assistance. 
This is a bit of a long shot, but I was curious to get the community's input. Today, I realized that both Slack and PasteBin use "codemirror" to handle their web code editor / syntax highlighting. ... See more...
This is a bit of a long shot, but I was curious to get the community's input. Today, I realized that both Slack and PasteBin use "codemirror" to handle their web code editor / syntax highlighting. With PasteBin, I had to examine the page source to confirm. With Slack, you can confirm it here: https://slack.com/libs/webapp I figured I would submit a feature request to codemirror to see if they could add a "language mode" for Splunk. However, my issue was immediately closed with the response that codemirror does not implement new language modes, and it would be better implemented via a separate package. So I guess someone will have to create and maintain a language mode for codemirror for others to use if they want SPL support. Unfortunately, I do not have the experience to do this. But looking around, it appears GraphQL built their own codemirror language code package...so I was thinking...even if it's a long shot, maybe I can send the idea to Splunk and see what happens. Where would be the appropriate place to send this suggestion in to Splunk to see if that's something they'd be interested in implementing? I tried checking the ideas submission, but there are no categories where this idea would fit. I think it would be awesome if one day we could have Splunk syntax highlighting support in Slack (and also PasteBin, but there's a lot less people using that lol).
Hello,  I have three search query below that I want to combine the three metric name sum into one total count. Can someone able to assist how I can write my query? First Query: | mstats sum(vault.... See more...
Hello,  I have three search query below that I want to combine the three metric name sum into one total count. Can someone able to assist how I can write my query? First Query: | mstats sum(vault.token.creation.nonprod) as count where index=vault_metrics span=1h | timechart sum(count) as count span=1h | fillnull value=0 | eventstats perc90(count) perc50(count) Second Query: | mstats sum(vault.token.creation.dev) as count where index=vault_metrics span=1h | timechart sum(count) as count span=1h | fillnull value=0 | eventstats perc90(count) perc50(count) Third Query: | mstats sum(vault.token.creation.nonprod_preprod) as count where index=vault_metrics span=1h | timechart sum(count) as count span=1h | fillnull value=0 | eventstats perc90(count) perc50(count)
Here is my kv store lookup  name rating comment experience  subject A 3 good 4 math B 4 very good 7 science   now i want to append new row like t... See more...
Here is my kv store lookup  name rating comment experience  subject A 3 good 4 math B 4 very good 7 science   now i want to append new row like this with different rating name rating comment experience  subject A 3 good 4 math B 4 very good 7 science A 5 Excellent  4 math   i am trying to use      | inputlookup table_a |search name="A" |eval rating=5 ,comment="Execellent" key=_key| outputlookup append=true key_field=key table_a     But this is not working..Please someone help me with this..   Thanks
Hi here is couple of old answers what you should consider when running splunk on VMware. https://community.splunk.com/t5/Splunk-Enterprise/Why-am-I-receiving-this-error-message-IOWait-Resource-usa... See more...
Hi here is couple of old answers what you should consider when running splunk on VMware. https://community.splunk.com/t5/Splunk-Enterprise/Why-am-I-receiving-this-error-message-IOWait-Resource-usage/m-p/578077#M10932 https://community.splunk.com/t5/Knowledge-Management/Moving-splunk-setup-from-standalone-to-a-search-peer-and-and/m-p/649116 https://community.splunk.com/t5/Splunk-Enterprise/Splunk-Instances-Utilizing-HIGH-CPU-Usage-in-VMware-Environment/m-p/567917 You must check IOPS for whole ESXi level + VM level. Also ensure that vCpu count is less than core count in smallest socket. r. Ismo
Hi, Is there anyway to get the p(95) of URI1, URI2, URI3 if the p(95) of URI4 is greater than 2sec. I tried the below query, but it’s giving the p(95) on only those URIs whose p(95)>2. I’m expecti... See more...
Hi, Is there anyway to get the p(95) of URI1, URI2, URI3 if the p(95) of URI4 is greater than 2sec. I tried the below query, but it’s giving the p(95) on only those URIs whose p(95)>2. I’m expecting p(95) of all URI1, URI2, URI3 if the condition is sarisfied index=myindex URI in (URI1, URI2, URI3, URI4) | stats perc95(responsetime) as p95 by URI | where p95>2
Hello, How to outputlookup csv with permission?   ***Note that I am not Splunk admin - I only have access to Splunk GUI***   Please help. Thank you so much For example:  | outputlookup test.cs... See more...
Hello, How to outputlookup csv with permission?   ***Note that I am not Splunk admin - I only have access to Splunk GUI***   Please help. Thank you so much For example:  | outputlookup test.csv It will create test.csv in the following directory with no owner and sharing:Global  I am able to delete it, but I could not modify the permission. How to outputlookup csv and set to sharing:App and I am the owner? /opt/splunk/etc/apps/testapp/lookups/test.csv    Owner: No owner    App: testapp   Sharing: Global    Status Enabled
You could try eval foo = bar . “(“ . zaa . “%)” or something similar. Then fields - <other unneeded fields>
Were you able to find a solution for this?
I need to find abnormalities in my data. The data I have is individual views for certain movie titles. I need to find content that was abnormally popular over some small time interval, say 1 hour. An... See more...
I need to find abnormalities in my data. The data I have is individual views for certain movie titles. I need to find content that was abnormally popular over some small time interval, say 1 hour. And check a few weeks worth of data. One option is to run a query manually for each hour       ``` Run this over 60m time window ``` index=mydata | top limit=100 movieId       Obviously I don't want to run this query 24 * 7 = 168 times for one weeks worth of data. How can I bin the data into time buckets, and get a percentage ratio by movieId? This is what I came up with:       ``` Run this over 1+ week ``` index=mydata | bin span=60m _time | top limit=100 movieId, _time       This does not help me because the output of `top` is showing me a percentage based on the entire input set of data. I need a "local" percentage, i.e. a percentage based on only that slice of data in the bin.   I'm wondering if eventstats or streamstats can be useful here but I was not able to come up with a query using those commands
i dont see the stats coming here with stats command as well  index=address-validation RESP_MARKER | rex field=log "\"operationPath\"\:\"(?<path>\w+).*\"operationType\"\:\"(?<type>\w+).*\"region\"\... See more...
i dont see the stats coming here with stats command as well  index=address-validation RESP_MARKER | rex field=log "\"operationPath\"\:\"(?<path>\w+).*\"operationType\"\:\"(?<type>\w+).*\"region\"\:\"(?<reg>\w+).*" | stats count by path, type, reg
Yes I have - that was the GitHub link I posted. Actually they were very quick to address it (and a second issue I found after identifying the first). It sounds like their GitHub code has been updated... See more...
Yes I have - that was the GitHub link I posted. Actually they were very quick to address it (and a second issue I found after identifying the first). It sounds like their GitHub code has been updated, but not the version loaded on SplunkBase yet.
That's a supported app.  Have you contacted the developer?
The queries do not contain statistics-generating commands (stats, timechart, etc.) so there is nothing for the Statistics tab to show.
Hello @Michael.Lee, We have some news for you, check out this latest announcement. https://community.appdynamics.com/t5/News-Announcements/Announcing-Bi-directional-Integration-of-Cisco-AppDynamics... See more...
Hello @Michael.Lee, We have some news for you, check out this latest announcement. https://community.appdynamics.com/t5/News-Announcements/Announcing-Bi-directional-Integration-of-Cisco-AppDynamics-and/ba-p/51898 cc @Courtney.Dragoon 
You might also want to give a try to logcraft.io you can version knowledge objects individually and deploy them where you want, that's repository for splunk
Hi  Hi, If i select "MM" ,How do i get entity associated(ie materia;,supplied material) to that particular domain...My second drop has static values which then fetch the results for 4 different q... See more...
Hi  Hi, If i select "MM" ,How do i get entity associated(ie materia;,supplied material) to that particular domain...My second drop has static values which then fetch the results for 4 different queries parallely when i select from data entity.then later how do i perform multiselect option for (material and supplied material)
Hi @ITWhisperer  Not sure what you mean by re-using field name severity as Column_1 is the object and column_2 is the severity Here is what some output looks like for  | table tool host object_c... See more...
Hi @ITWhisperer  Not sure what you mean by re-using field name severity as Column_1 is the object and column_2 is the severity Here is what some output looks like for  | table tool host object_class object severity parameter value message support_group Ignore the first column (I put that in for explanation purposes)   tool host object_class object severity parameter value message support_group 1 Tool ServerA OS_INCIDENT ServerA.zabbix:1380217:Warning WARNING OS_ISSUE_NUM 1380217 ServerA - Disk space is at 80% OS  Support 2 Tool ServerA OS_INCIDENT ServerA.zabbix:1380217:Critical CRITICAL OS_ISSUE_NUM 1380217 CALL OUT - ServerA - Disk Space is at 90% OS Support 3 Tool ServerA OS_INCIDENT ServerA.zabbix:1380217:Clear CLEAR OS_ISSUE_NUM 1380217 ServerA -Disk Space Clear OS  Support                     4 Tool ServerA OS_INCIDENT ServerA.zabbix:1380217:Warning CLEAR OS_ISSUE_NUM 1380217 ServerA -Disk Space Clear OS  Support 5 Tool ServerA OS_INCIDENT ServerA.zabbix:1380217:Critical CLEAR OS_ISSUE_NUM 1380217 CALL OUT - ServerA - Disk Space Clear OS Support What I am currently getting is 1,2,3, however what I need is 1 and 2, and when I get a result like 3, change it be 4 and 5 Hope that makes sense
Hello Splunk community, I'm in the process of installing Splunk for the first time on a Windows server. I've followed the official installation guide, but I've encountered an issue during the instal... See more...
Hello Splunk community, I'm in the process of installing Splunk for the first time on a Windows server. I've followed the official installation guide, but I've encountered an issue during the installation process. After running the installer, I received an error message that says 'Error 123: The filename, directory name, or volume label syntax is incorrect.' I've double-checked the installation path and made sure there are no special characters, but I still can't seem to get past this error. Has anyone else experienced this issue during installation? What steps can I take to resolve it and successfully install Splunk on my Windows server? Any help would be greatly appreciated. Thank you!