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?
(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)
Thanks Mary!
(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)