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!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...