Splunk Search

showing chart based on Time and Transaction count

avikc100
Path Finder

this is the log data

avikc100_0-1718892426100.png

 

i want a report like this:

avikc100_1-1718892579363.png

 

 

my current query is :
index="webmethods_prd" source="/apps/WebMethods/IntegrationServer/instances/default/logs/DFO.log" |eval timestamp=strftime(_time, "%F") | stats values(B2BUnknownTrxCount) by timestamp

it giving report like this:

avikc100_2-1718892638716.png

I need to add date time in hh:mm in a chart. 
Please help to update my query

Labels (2)
0 Karma
1 Solution

macalamela
Engager

 

index="webmethods_prd" source="/apps/WebMethods/IntegrationServer/instances/default/logs/DFO.log"
| eval timestamp=strftime(_time, "%F"),hour=strftime(_time, "%H,%M") 
| stats list(hour) as hour, list(B2BUnknownTrxCount) by timestamp

View solution in original post

0 Karma

avikc100
Path Finder
index="webmethods_prd" source="/apps/WebMethods/IntegrationServer/instances/default/logs/DFO.log" |eval timestamp=strftime(_time, "%Y-%m-%d %H:00") | stats values(B2BUnknownTrxCount) by timestamp
0 Karma

macalamela
Engager

 

index="webmethods_prd" source="/apps/WebMethods/IntegrationServer/instances/default/logs/DFO.log"
| eval timestamp=strftime(_time, "%F"),hour=strftime(_time, "%H,%M") 
| stats list(hour) as hour, list(B2BUnknownTrxCount) by timestamp

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour  Prepare to ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...