Splunk Search

How to append multiple columns to get result

aaa2324
Explorer

I am looking to get the data in year, month, day, hour, minute and second basis

search criteria is index="abc" rex field=raw"few fields" | stats count yearcount by year

The above query is giving me below columns

year      yearcount

2023      10

Similar to the above query we want to get count of month, day...seconds

the final output should have below table

year   yearcount   month   monthcount   day  daycount  ......seconds   secondscount

Is it possible to get this output without using appendcols function multiple time as it is making the search query very long and not effective.

 

Labels (1)
Tags (1)
0 Karma

PickleRick
SplunkTrust
SplunkTrust

Apart from @ITWhisperer 's solution (which is sound in itself) question is how would you interpret such results.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

index="abc" rex field=raw"few fields"
| bin _time as seconds span=1s
| bin _time as minutes span=1m
| bin _time as hours span=1h
| bin _time as days span=1d
| bin _time as months span=1mon
| bin _time as years span=1y
| stats count secondscount by seconds minutes hours days months years
| eventstats sum(secondscount) as minutescount by minutes
| eventstats sum(secondscount) as hourscount by hours
| eventstats sum(secondscount) as dayscount by days
| eventstats sum(secondscount) as monthscount by months
| eventstats sum(secondscount) as yearscount by years
0 Karma
Get Updates on the Splunk Community!

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...