Splunk Search

How to append multiple columns to get result


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


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

0 Karma


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!

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...

We’ve Got Education Validation!

Are you feeling it? All the career-boosting benefits of up-skilling with Splunk? It’s not just a feeling, it's ...