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!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...