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!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...