Splunk Enterprise

Need help with Splunk Query

nilbak1
Communicator

Hello Splunkers,

I need help with below scenario:

I need to form query from xml log in below format.

TransactionID            LineNumber            Fulfiller
123                                        1                             abc
124                                         1                            xyz
125                                         1                            def
                                                  2                           xyz
126                                          1                           abc
                                                   2                           def
                                                   3                            xyz

So, here in my xml logs sometime i am having only one LineNumber mentioned and correspondingly fulfiller.
However, in some log events i am having multiple LineNumbers with corresponding fulfillers for same transactionid.

I have used regex to extract transactionid, LineNumber and fullfiller name.

I want result in above format.
Hope I am able to explain my scenario.

 

0 Karma
1 Solution

thambisetty
SplunkTrust
SplunkTrust

Try below,

my Query | stats list(LineNumber) as LineNumber list(Fullfiller) by TransactionID


values function displays only distinct values.

where as list displays linenumber and its fulfiller by transactionID

 

————————————
If this helps, give a like below.

View solution in original post

nilbak1
Communicator

After using max_match in regex and running below query

my Query | stats values(LineNumber) as LineNumber values(Fullfiller) by TransactionID

I am getting as below result 

10000056090658 1 abc
10000063819764 1 xyz
                                        2
10000063819784 1 abc
                                        2 def

10000063820877 1 abc
                                        2
Not getting fulfillers with some of the line numbers.

0 Karma

thambisetty
SplunkTrust
SplunkTrust

Try below,

my Query | stats list(LineNumber) as LineNumber list(Fullfiller) by TransactionID


values function displays only distinct values.

where as list displays linenumber and its fulfiller by transactionID

 

————————————
If this helps, give a like below.

nilbak1
Communicator

Thanks @thambisetty 

Yes, I used list function and it worked, got the results as required.

Anyways thanks for your reply.

Tags (1)
0 Karma

thambisetty
SplunkTrust
SplunkTrust
Happy I solved your problem. Please like answer.
————————————
If this helps, give a like below.
0 Karma

Nisha18789
Builder

hi @nilbak1 , can you share the regex you are using ? Or the log?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...