Splunk Search

Group events by mutiple fields

DeXteR
New Member

Hi I have some events in splunk which are of this form-

Location: some value(same value can be there in multiple events)

Client: some value(same value can be there in multiple events)

TransactionNumber: some value(Unique for each event)

Transaction Time: some value(Unique for each event)

Now I want a table in this form -

 

Screenshot 2020-09-01 at 8.22.58 PM.png

Basically each location can have multiple clients and each client can have different transactions. Transaction number and transaction time are unique and have one to one mapping.

I am using this query in splunk-

| stats list(TransactionNumber) list(TransactionTime) by Location Client

What's happening is I am getting unique combination of location and client but what I want is unique clients to be listed against a particular Location.

This is what i am getting-

 

Screenshot 2020-09-01 at 8.24.06 PM.png

How can the query be modified to achieve the same?


 
Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

The only difference I see is the empty cells in the Location field.  Is there something else?

---
If this reply helps you, Karma would be appreciated.
0 Karma

DeXteR
New Member

Yes

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...