Splunk Search

How to convert column multivalue field to a single row

mlevsh
Builder

Hi,

I need to get the list of indexes with the roles on them.
I use the following search:

| rest /services/authorization/roles splunk_server="local"
| table title, srchIndexesAllowed

The result is displayed in the following format:
     index1   role1
                      role2
     index2   role1
                      role3

How do I display it in the following form:
     index1 role1 role2
     index2  role1 role3 

Thank you!

 

Labels (1)
Tags (1)
0 Karma

ITWhisperer
Legend

It is not clear whether you expect the roles to be in separate fields or a single (string) field

| mvcombine role | nomv role
0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!