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!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...