Reporting

Showing index name as an alias in report

runiyal
Path Finder

I am trying to get count of rows in each index. Here is the search creteria -

(index=abc <search creteria 1>) OR (index=xyz <search creteria 2>) | stats count by index

Result is like -

Index    Count
abc 100
xyz 98

But I need to have different name in the report for the indexes. I would like to have report like -

Index    Count
Index1  100
Index2  98

How can we achieve this? How to change name of the index?

Tags (3)
0 Karma
1 Solution

marycordova
SplunkTrust
SplunkTrust
(index=abc <search creteria 1>) OR (index=xyz <search creteria 2>)
| stats count by index
| eval index=case('index'=="abc","Index1",'index'=="xyz","Index2",etc)
@marycordova

View solution in original post

0 Karma

runiyal
Path Finder

Thanks Mary!

marycordova
SplunkTrust
SplunkTrust
(index=abc <search creteria 1>) OR (index=xyz <search creteria 2>)
| stats count by index
| eval index=case('index'=="abc","Index1",'index'=="xyz","Index2",etc)
@marycordova
0 Karma
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...