Splunk Search

result of makemv not as expected

rrovers
Path Finder

With this search

index=useradmin sourcetype=role_capabilities
| eval capabilities=replace(capabilities,"\s",",")
| makemv delim="," capabilities
| table role capabilities

I expected a result like

role1 capability1

role1 capabiltity2

role1 capabitity3

role 2 capability1

instead I get

role 1 capabilty1

            capabilty2

            capabilty3

role 2 capability1

Probably my expectations of makemv are not correct but I can't find another command to make this work.

The reason I want it in this way is to get layout of the print of the dashboard I use this with properly.

 

 

Labels (2)
0 Karma
1 Solution

493669
Super Champion

@rrovers try using mvexpand comand on your results set-

...|mvexpand capabilities

View solution in original post

rrovers
Path Finder

@493669, thanks, that's what I was looking for

0 Karma

493669
Super Champion

@rrovers  Please accept it as solution to help future readers as well.

0 Karma

493669
Super Champion

@rrovers try using mvexpand comand on your results set-

...|mvexpand capabilities

View solution in original post

.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!