All Topics

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

All Topics

I know this question has been asked a lot before, and I've tried implementing the answers, but I must be doing something wrong because it is not working for me. I have a graph with rooms on the x axi... See more...
I know this question has been asked a lot before, and I've tried implementing the answers, but I must be doing something wrong because it is not working for me. I have a graph with rooms on the x axis and count on the y axis. Each room could be in any of 6 buildings in the data set. I want to color the bars based on the building that the room is in.    This is my search index="example"  Point_Name=Count  |$v_hours$ |where isnum(value) |stats max(value) as PeakCount by Building, Room |eval building=case(Building=="Building1", "B1") |sort -PeakCount |rename PeakCount as Count |head 10 |table Room, Count   This is my xml     <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option> <option name="charting.axisLabelsX.majorLabelStyle.rotation">-90</option> <option name="charting.axisTitleX.visibility">visible</option> <option name="charting.axisTitleY.visibility">visible</option> <option name="charting.axisTitleY2.visibility">visible</option> <option name="charting.axisX.scale">linear</option> <option name="charting.axisY.scale">linear</option> <option name="charting.axisY2.enabled">0</option> <option name="charting.axisY2.scale">inherit</option> <option name="charting.chart">column</option> <option name="charting.chart.bubbleMaximumSize">50</option> <option name="charting.chart.bubbleMinimumSize">10</option> <option name="charting.chart.bubbleSizeBy">area</option> <option name="charting.chart.nullValueMode">gaps</option> <option name="charting.chart.showDataLabels">none</option> <option name="charting.chart.sliceCollapsingThreshold">0.01</option> <option name="charting.chart.stackMode">default</option> <option name="charting.chart.style">shiny</option> <option name="charting.drilldown">all</option> <option name="charting.seriesColors">{"B1":0xFF0000}</option> <option name="charting.layout.splitSeries">0</option> <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option> <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option> <option name="charting.legend.placement">right</option> <option name="height">462</option>       If I table building, count then B1 is labeled on the xaxis under the correct bar, but the color still does not change. What am I missing?
Hi, I would like to create a chart of the error rate over time.  I have data that shows status= DOWNLOAD_COMPLETE  and status = FAILD I can calculate this for a point in time with the below. But ca... See more...
Hi, I would like to create a chart of the error rate over time.  I have data that shows status= DOWNLOAD_COMPLETE  and status = FAILD I can calculate this for a point in time with the below. But can anyone help get the error rate over time?   logType=error OR logType=service context=retrieve status=DOWNLOAD_COMPLETE OR status=FAILED | stats count(correlationId) as total_count by status | transpose header_field=status | eval errorRate=FAILED/(FAILED+DOWNLOAD_COMPLETE)*100 | table DOWNLOAD_COMPLETE, FAILED, errorRate  
Hello, Does anyone have any idea why this keeps occuring? It happens to me about every 10 minutes. The session timeout is set to 60 minutes. We use SAML with Okta for authentication. I asked the Okt... See more...
Hello, Does anyone have any idea why this keeps occuring? It happens to me about every 10 minutes. The session timeout is set to 60 minutes. We use SAML with Okta for authentication. I asked the Okta personnel and they said they have a 2 hour time out session.    Any help is greatly appreciated! V/r, mello920
So, I am trying to use a lookup table spammer.cvs to filter out results from my search but can't get the filtering logic down to make it work completely. Table A1Sender, A1Sender_domain, A2Sender, ... See more...
So, I am trying to use a lookup table spammer.cvs to filter out results from my search but can't get the filtering logic down to make it work completely. Table A1Sender, A1Sender_domain, A2Sender, A2Sender_domain, Recipient{} fred@flintstone.com, ,tinker@sbuggy.com, , ,  ,*@bbunny.com,mmouse@wd.com, , ,  ,*@wd.com, ,*@bbunny.com, ,  , , , ,myemail@me.com I can get this to work; {my search} | search NOT [ | inputlookup spammer.csv | fields A1Sender, A2Sender] | table _time, A1Sender,  A2Sender How do I code something like; {my search} | search NOT [ | inputlookup spammer.csv | fields A1Sender, A2Sender | fields A1Sender_domain, A2Sender | fields A1Sender_domain, A2Sender_domain | fields Recipient{}] | table _time, A1Sender,  A2Sender
Hi I would like to know if it is possible to use a bin span with now() like with _time? bin _time span=1h Thanks 
|>TYPE|2022-04-25 18:38:40|2d7e908bo82cb8|1725357403659|HERE|TYPE/272|1,856|1.2.0|ABC|351c481f2de|NONE<| |>TYPE|2022-04-25 18:38:19|8e61ty7ebd2c25|1725357403659|THERE|TYPE/272||1.2.0|ABCD|4552aa7f... See more...
|>TYPE|2022-04-25 18:38:40|2d7e908bo82cb8|1725357403659|HERE|TYPE/272|1,856|1.2.0|ABC|351c481f2de|NONE<| |>TYPE|2022-04-25 18:38:19|8e61ty7ebd2c25|1725357403659|THERE|TYPE/272||1.2.0|ABCD|4552aa7f9ebd704a91c8|{authType}|{ "message": { "number": "1856345" }, "transaction": { "sample1": "value1", "sample2": "value2" }}<|<| I am looking for collecting data from both of above message and correlate between two. I am looking for numbers 272 and 1,856 from HERE and looking for sample1 and sample2 from THERE both HERE and THERE will have 272 common and that is the only one. build a table between those two with sample1, sample2, 1,856
Hello Splunkers, How can i rename all the OrderNumber1, OrderNumber2, OrderNumber3 as OrderNumber. And Country1, Country2,Country4 as Country. I have attached the screenshot also.    Appreciate... See more...
Hello Splunkers, How can i rename all the OrderNumber1, OrderNumber2, OrderNumber3 as OrderNumber. And Country1, Country2,Country4 as Country. I have attached the screenshot also.    Appreciated in advance    
Hello there,  For context, I got some remote logs from different sources on my universal forwarder, and I'm trying to index logs from the same source with the same index, but the thing is, I don't ... See more...
Hello there,  For context, I got some remote logs from different sources on my universal forwarder, and I'm trying to index logs from the same source with the same index, but the thing is, I don't know how to that I tried to follow this Create custom indexes - Splunk Documentation, but even trying to index everything that comes from my universal forwarder using this [tcp://<ip_addr_forwarder] index=<name_of_index] can someone help please ? Best regards,
is there away we can search for a ,  to find multi locale or multi country basically instead of the underlined index=personmetrics logtype=personactivity wrk_grp="Ret,Ce" locale="en-US,en-GB" ... See more...
is there away we can search for a ,  to find multi locale or multi country basically instead of the underlined index=personmetrics logtype=personactivity wrk_grp="Ret,Ce" locale="en-US,en-GB" 1.  how do we write? index=ccpmetrics logtype=ccpactivity (wrk_grp LIKE "," OR locale LIKE ",") |table personname,wrk_grp,locale 2. bonus point: and then find the stats of personname and corresoponding entries.
How do I extract all fields from userdata?   accept=application/json, timestamp=1651243086870} OutboundWebHookPayload={"clientType":"Client","mediaType":"ask","subject":"EscapeClient","userData"... See more...
How do I extract all fields from userdata?   accept=application/json, timestamp=1651243086870} OutboundWebHookPayload={"clientType":"Client","mediaType":"ask","subject":"EscapeClient","userData":{"country":"UK","lastName":"ELMER","agentId":"7060856","conversationId":"conv_1d55ec01e970c8833e8b8206be287fce","sessionId":"itc_58f7ad65-fcb0-46bd-81-1717f84dd7","chatSessionId":"s_eaf99b35-59fd-4d36-8f8f-c6423f8ec610","locale":"en-GB","languageCode":"en","experience":"Default","publicGuid":"1d55ec01e970c8833e8b8206be287fce","accountNumber":"XXXXXXXXXXXXXXX","firstName":"LUKE","environment":"prod","intentCode":"statement_balance","upfrontRoutingIntent":"CardServices","InteractionType":"Resume","customerId":"508558871407","channelName":"MApp","ProductType":" Card"}}     I tried   userData | rex field=_raw "userData.:{.IACode.:.(?<IACode>[A-Za-f0-9]+).,.country.*upfrontRoutingIntent.:.(?<upfrontRoutingIntent>[^\"]+).," | table IACode upfrontRoutingIntent   But I need other fields like Experience and Product type as well  
Hello,  I'm having troubles creating a dashboard panel that can list values inserted by other users. The panel has an input field where users will put specific ip addressess that mast be added to th... See more...
Hello,  I'm having troubles creating a dashboard panel that can list values inserted by other users. The panel has an input field where users will put specific ip addressess that mast be added to this "list".  The only solution i came up with is a lookup file that will be updated with new rows every time a user adds a value as input. I have tried this query that i saw on https://blog.avotrix.com/how-to-add-new-fields-in-existing-lookup-file/ :  | inputlookup ip_sospetti append=true | append [| stats count | eval IP="$added_ip_token$" | table IP] | outputlookup ip_sospetti.csv This search adds just one value to the lookup file and when a new input is added it changes the last value inserted. Do you guys have a better solution or maybe an idea to make this query work? Thanks a lot.
Hi all,  I would like to configure the splunk on call slack add on but when an admin wanted to approve the integration, it requested the following permissions: 11 permissions and scopes require... See more...
Hi all,  I would like to configure the splunk on call slack add on but when an admin wanted to approve the integration, it requested the following permissions: 11 permissions and scopes required On behalf of the app: - View messages and other content in public channels that VictorOps has been added to channels:history - View messages and other content in private channels that VictorOps has been added to groups:history - Add shortcuts and/or slash commands that people can use commands - View the name, email domain and icon for workspaces VictorOps is connected to team:read - Send messages as @victorops chat:write - Send messages as @victorops with a customised username and avatar chat:write.customize On behalf of the user: - View information about a user’s identity identify - View basic information about public channels in a workspace channels:read - View basic information about a user’s private channels groups:read - Manage a user’s public channels and create new ones on a user’s behalf channels:write - Manage a user’s private channels and create new ones on a user’s behalf groups:writeAll actions on a request will affect the entire workspace Question 1: Just doing due diligence here, does the last permission "Manage a user’s private channels" give it the ability to read messages on other private channels on the workspace?  reading in the knowledge base it states: "Note: The scope of private channels is limited to the channels that the person who integrates Splunk On-Call to Slack has access to. If you would like all private channels to be mapped to Splunk On-Call, we recommend creating a “Service Account” that has access to all private channels for this use." Question 2 - does this mean the app would have access to all channels the admin user who approves to integration by default? Or would they approve it per channel? 
Hi ! I wonder how to correct the following behaviour. Here's my architecture : 1 dns entry point load balancing between 2 forwarders on port 8088 for Http Event Collector (HEC). behind that 1... See more...
Hi ! I wonder how to correct the following behaviour. Here's my architecture : 1 dns entry point load balancing between 2 forwarders on port 8088 for Http Event Collector (HEC). behind that 1 indexer (monoinstance). indexer ack activated for one collect serie (one index with one sourcetype).   When sending event, an IdAck is answered back to check if the event is correctly received by the indexer.   Problem : 2 different events can have the same ackID ! I suppose it is because of the load balancing and each ackID list is linked to each forwarder. As the query is balanced, I cannot know if I will be answerd be the fw1 or 2.   Event1 is processed by fw1 with idAck = 7 Event2 is processed by fw2 with idAck = 7 (also !!)   When asking for indexing ack status for idAck7 : my query can be processed by fw1 or 2, but the answer cannot be meaningful because I don't know which event I'm asking about.   How do we go around this behaviour ? Does this mean I can't load balance the entrypoint in front of the forwarder ? In this case, how am I supposed to allow high availability of the service ?   Thank your a lot in advance for you insights   Ema
hi everyone,   can someone please advice me how to set up kubernetes for splunk ? i want to use the below splunk add on https://splunkbase.splunk.com/app/3991/#/details please  
I am trying to remove warning from my dashboard. Because 'Advanced XML isn't supported and it has to be replaced with Simple XML'. I am stuck at this code where the error says, Unknown Option nam... See more...
I am trying to remove warning from my dashboard. Because 'Advanced XML isn't supported and it has to be replaced with Simple XML'. I am stuck at this code where the error says, Unknown Option name = 'displayRowNumbers' for node 'table' Unknown Option name = 'linkFields' for node 'table' Unknown Option name = 'linkView' for node 'table' The code is, <title>Base search</title> <option name="count">10</option> <option name="displayRowNumbers">false</option> <option name="linkFields">result</option> <option name="linkView">flashtimeline</option> Any suggestion what to replace my code with ?
Regex for  From:  FA.south dam.australia-mb.ccjbh need to get only: ccjbh 
I'm trying to calculate the milliseconds between two events by same transactionId, and then show in a timechart Here my current query   "My event 1" | stats latest(_time) as time_login by tran... See more...
I'm trying to calculate the milliseconds between two events by same transactionId, and then show in a timechart Here my current query   "My event 1" | stats latest(_time) as time_login by transactionId |join transactionId [search "My event 2" | stats latest(_time) as time_finish by transactionId] | eval difference=time_finish-time_login   This query works really slow and half of the time it does not work, but if I try to add this to the end of the query   | timechart avg(difference) 
I've recently installed Splunk_TA_nix and started using the "ps" script. The data is ingested into my ES. However it is not translated into CIM Endpoint.Processes object, because it lacks "report" ta... See more...
I've recently installed Splunk_TA_nix and started using the "ps" script. The data is ingested into my ES. However it is not translated into CIM Endpoint.Processes object, because it lacks "report" tag.  I know I can add it by crafting my own tags.conf file. However, most of the default configurations in Splunk are configured as they are for some reason. So, what it the reason not to have "report" tag for Linux scripted sourcetypes? Below an example of tags.conf part for ps eventtype stanza: [eventtype=ps] performance = enabled cpu = enabled success = enabled ps = enabled oshost = enabled process = enabled
Hi All,    I have number of events with error srtring in event. I need to fetch al the events with error string except hibernet errors. "ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - O... See more...
Hi All,    I have number of events with error srtring in event. I need to fetch al the events with error string except hibernet errors. "ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-00001: unique constraint" I am not sure about the logs with other errors..as there are multiple logs with hibernate error ..i cant be able to fetch it. i need to extract all other logs with error keyword in the event. Can anyone please help me on the same. Thanks in advance.
Hi Is it possible to round the current time in a quarter of hour ( quarter superior) For exemple if its 9h56 i would like to diplay 10:00 and 11:42 i would like to display 11:45 Thanks