Splunk Search

Consolidating table entries

dwear
Explorer

192.168.1.7 |table Realm, Role

I have a search and I'm trying to consolidate to unique combinations of Realm and Role.

 Realm         Role
 Realm A      Role A
 Realm A      Role A
 Realm A      Role A
 Realm A      Role B
 Realm A      Role A
 Realm B      Role B
 Realm B      Role C

As you can see above, there is duplicates. I tried "|dedup Realm" but I feel like its eliminating some unique combinations by eliminating duplicate Realms. I'd like see if look like this.

 Realm         Role
 Realm A      Role A
 Realm A      Role B
 Realm B      Role B
 Realm B      Role C
Tags (1)
0 Karma

Stevelim
Communicator
| stats values(Realm)  as Realm, values(Role)  as Role
0 Karma

woodcock
Esteemed Legend

Use 2 fields, like this:

192.168.1.7 | dedup Realm Role | table Realm Role
0 Karma

javiergn
Super Champion

Faster and nicer than dedup:

| stats count by Realm, Role
| fields - count
0 Karma
Get Updates on the Splunk Community!

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...

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

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...