Splunk Dev

extract a multiline field value into multiple events

yashaswinig2210
Engager

Hi,

I have a query which gives GroupName and its members in the below format

 

GroupName                    member
Domain Admins  CN=firstname1\, lastname1 P0,OU=P0-Accounts,OU=test OU
                                   CN=firstname2\, lastname2 P1,OU=P1-Accounts,OU=test OU
                                   CN=firstname3\, lastname3 P3,OU=P3-Accounts,OU=test OU

And im trying to extract it in multiple events like below seperately for each and every member

GroupName                    member
Domain Admins            CN=firstname1\, lastname1 P0,OU=P0-Accounts,OU=test OU
 Domain Admins           CN=firstname2\, lastname2 P1,OU=P1-Accounts,OU=test OU
 Domain Admins           CN=firstname3\, lastname3 P3,OU=P3-Accounts,OU=test OU

 

 

 

Labels (2)
0 Karma
1 Solution

renjith_nair
Legend

Does mvexpand work for you?

"your search"
|mvexpand member

 

---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

0 Karma

renjith_nair
Legend

Does mvexpand work for you?

"your search"
|mvexpand member

 

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma

yashaswinig2210
Engager

@renjith_nair  No mvexpand didnt work

0 Karma

renjith_nair
Legend

Ok , so why didn't work, is it not a multi value field? or can you share the search which results in the existing state?

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma

yashaswinig2210
Engager

Hey thanks now I realised my mistake i have used mvexpand on my lookup so it didnt work and now I tried mvexpand on actual index and sourcetype its working fine

 

0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...