Deployment Architecture

How can I add the index to the fieldsummary as an extra column?

datitran
New Member

If I do index=* | fieldsummary I get the fieldsummary of all indices.
How can I add the index to the fieldsummary as an extra column, so that I will have:

index, field, count, distinct_count, ..., values

0 Karma
1 Solution

somesoni2
Revered Legend

Try this (slower performance)

| eventcount summary=f index=* | table index
| map maxsearch=1000 search="search index=$index$ | fieldsummary | eval index=\"$index$\""
| table index * 

OR

| rest /services/data/indexes | table title | dedup title 
| map maxsearch=1000 search="search index=$title$ | fieldsummary | eval index=\"$title$\""
| table index * 

View solution in original post

0 Karma

somesoni2
Revered Legend

Try this (slower performance)

| eventcount summary=f index=* | table index
| map maxsearch=1000 search="search index=$index$ | fieldsummary | eval index=\"$index$\""
| table index * 

OR

| rest /services/data/indexes | table title | dedup title 
| map maxsearch=1000 search="search index=$title$ | fieldsummary | eval index=\"$title$\""
| table index * 
0 Karma
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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