{   "abcdxyz" : {     "transaction" : "abcdxyz",     "sampleCount" : 60,     "errorCount" : 13,     "errorPct" : 21.666666,     "meanResTime" : 418.71666666666664,     "medianResTime" : 264.5,     "minResTime" : 0.0,     "maxResTime" : 4418.0,     "pct1ResTime" : 368.4,     "pct2ResTime" : 3728.049999999985,     "pct3ResTime" : 4418.0,     "throughput" : 0.25086548592644625,     "receivedKBytesPerSec" : 0.16945669591340123,     "sentKBytesPerSec" : 0.3197146692547623   },   "efghxyz" : {     "transaction" : "efghxyz",     "sampleCount" : 60,     "errorCount" : 13,     "errorPct" : 21.666666,     "meanResTime" : 421.8,     "medianResTime" : 32.0,     "minResTime" : 0.0,     "maxResTime" : 3566.0,     "pct1ResTime" : 3258.5,     "pct2ResTime" : 3497.6,     "pct3ResTime" : 3566.0,     "throughput" : 0.24752066797577596,     "receivedKBytesPerSec" : 0.34477244084256037,     "sentKBytesPerSec" : 0.08463804872238082   },   "ijklxyz" : {     "transaction" : "ijklxyz",     "sampleCount" : 60,     "errorCount" : 13,     "errorPct" : 21.666666,     "meanResTime" : 27.733333333333338,     "medianResTime" : 27.5,     "minResTime" : 0.0,     "maxResTime" : 241.0,     "pct1ResTime" : 41.599999999999994,     "pct2ResTime" : 52.699999999999974,     "pct3ResTime" : 241.0,     "throughput" : 0.25115636576738737,     "receivedKBytesPerSec" : 0.3331214746541367,     "sentKBytesPerSec" : 0.08588125143891667   },   "mnopxyz" : {     "transaction" : "mnopxyz",     "sampleCount" : 60,     "errorCount" : 13,     "errorPct" : 21.666666,     "meanResTime" : 491.74999999999994,     "medianResTime" : 279.5,     "minResTime" : 0.0,     "maxResTime" : 4270.0,     "pct1ResTime" : 381.29999999999995,     "pct2ResTime" : 4076.55,     "pct3ResTime" : 4270.0,     "throughput" : 0.2440254437195985,     "receivedKBytesPerSec" : 0.16483632755942018,     "sentKBytesPerSec" : 0.2839297997262848   } } I need to create a table view from the above log event which was captured as a single event, like the below table format: samples abcdxyz efghxyz ijklxyz mnopxyz     "transaction" :             "sampleCount"                                                     "errorCount"              "errorPct"                                                "meanResTime"                                    "medianResTime"                                          "minResTime"                                               "maxResTime"                                               "pct1ResTime"                                          "pct2ResTime"                                        "pct3ResTime"                                           "throughput"                                        "receivedKBytesPerSec"                                      "sentKBytesPerSec"                                 ... View more

Can the webhook payload for an Splunk alert be configured manually.?? I have Servicenow Api End Point and need to modify the payload for an alert. ... View more

My Objective is to create an Alert in ServiceNow whenever an failure alert triggered in SPlunk. I have installed Splunk Add on for ServiceNow and configured the connection setup.  I was able to successfully post the incident is ServiceNow with the default fields available in ServiceNow Incident Alert. However i need to update the Description field in ServiceNow with the details of Alert Name and Alert Result to identify why that alert triggered. ... View more

Looking for spl query to get the index wise log consumption for each months splitup for last 6 months ... View more

I am using ingest action to filter the log message before being indexed in splunk.. I want to include the message that matches only the keyword :ERROR: and :FATAL: rest all of the messages should not be indexed. Whereas in splunk ingest action has the filter to only exclude message not the include ... View more

i have all the below messages in the "response" field. {"errors": ["Message: Payment failed. Reason: Hi, we attempted to process the transaction but it seems there was an error. Please check your information and try again. If the problem persists please contact your bank."]} {"errors": ["Unable to retrieve User Profile with sub '2415d' as it does not exist"]} {"errors": ["Unable to retrieve User Profile with sub 'dfadf' as it does not exist"]} {"errors": ["Unable to retrieve User Profile with sub 'fdsgad' as it does not exist"]} {"errors": ["Unallocated LRW seat not found with product id fdafdsaddsfa and start datetime utc 2024-01-06T05:30:00+00:00 and test location id dfafdfa"]} {"errors": ["Unallocated LRW seat not found with product id sfgdfa and start datetime utc 2024-01-06T05:30:00+00:00 and test location id dsfadfsa"]} I wanted to display the result with the count as  Message: Payment failed. Reason: Hi, we attempted to process the transaction but it seems there was an error. Please check your information and try again. If the problem persists please contact your bank. Unable to retrieve User Profile with sub '***' as it does not exist Unallocated LRW seat not found with product id *** and start datetime utc 2024-01-06T05:30:00+00:00 and test location id *** ... View more

index="********" message_type =ERROR correlation_id="*" | eval err_field1 = spath(_raw,"response_details.body") | eval err_field2 = spath(_raw,"response_details") | eval err_field3 = spath(_raw,"error") | eval err_field4 = spath(_raw,"message") | eval err_final=coalesce(err_field1,err_field2,err_field3,err_field4) | table err_field1 err_field2 err_field3 err_field4 err_final i have the fields populating for err_field3 and err_field4.. but its not populating in the err_final. Attached the screenshot for reference ... View more

Hi,  I am getting the below error when i'm trying to configure the Webhook alert to post in Microsoft Teams.   12-19-2023 11:57:56.700 +0000 ERROR sendmodalert [292254 AlertNotifierWorker-0] - action=webhook STDERR - Error sending webhook request: HTTP Error 400: Bad Request   12-19-2023 11:57:56.710 +0000 INFO sendmodalert [292254 AlertNotifierWorker-0] - action=webhook - Alert action script completed in duration=706 ms with exit code=2   12-19-2023 11:57:56.710 +0000 WARN sendmodalert [292254 AlertNotifierWorker-0] - action=webhook - Alert action script returned error code=2 ... View more

I have two different logs where the error is capturing in different fields in each log message...(error_message and error_response) I have to capture the error_message and error_response without dropping the other logs.? Log 1 : message:"Lambda execution: exit with failure", message_type:"ERROR", error_message:"error reason update" Log 2 : message:"Lambda execution: exit with failure", message_type:"ERROR", error_response:"updated error reason" Expected Output : Error                                                   count 1. error reason update                  1 2. updated error reason                1 ... View more

\"message\": \"Invalid Application ID\", \"messages\": null, \"error_response\": null, Need to extract the above message field without dropping other log messages. Like Nodrop option  ... View more