Splunk Enterprise Security

How to achieve the transpose or xyseries

dtccsundar
Path Finder

Hi ,

I have  4 fields and those need to be in a tabular format .Out of which one field has the ratings which need to be converter to column to row format with count and rest 3 columns need to be same .

I have tried using transpose and xyseries but not able to achieve in both .

Ex : current table format

NameDomainAreaRating
Nsp -1ITEnd user serviceH
NSP-2ITMainframeM
NTS-10G&AENTL
NTL -05EPPDistributedM
WMC-04AEScorpL

 

How this can be changed to the below format using splunk search ,

Expected table format :

NameDomainAreaRating(H) countRating(M) count Rating(L) count
Nsp -1ITEnd user service100
NSP-2ITMainframe010
NTS-10G&AENT001
NTL -05EPPDistributed010
WMC-04AEScorp000

 

Please let me know how to achieve this in using Splunk search.

Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
<<your current search>>
| stats count(eval(Rating="H")) as RatingH, count(eval(Rating="M")) as RatingM, count(eval(Rating="L")) as RatingL by Name, Domain, Area
| table Name Domain Area RatingH RatingM RatingL
| rename RatingH as "Rating(H) count", RatingM as "Rating(M) count", RatingL as "Rating(L) count"
0 Karma

richgalloway
SplunkTrust
SplunkTrust

I think the stats command can do that.

<<your current search>>
| stats sum(eval(Rating="H")) as RatingH, sum(eval(Rating="M")) as RatingM, sum(eval(Rating="L")) as RatingL by Name, Domain, Area
| table Name Domain Area RatingH RatingM RatingL
| rename RatingH as "Rating(H) count", RatingM as "Rating(M) count", RatingL as "Rating(L) count"
---
If this reply helps you, Karma would be appreciated.
0 Karma

dtccsundar
Path Finder

Hi richgalloway,

Thank you for your search.

When i ran this search , i am not getting the count for RatingH,RatingM,RatingL.All these 3 fields are blank.

Please let me know how to bring the values/count using this search .

 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Please share the full query.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...