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!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...