Splunk Search

How can I get common values from data?

WXY
Path Finder

Now ,I want to get common values from data.
I use this command:

`index="new_1"  |stats list(oper_field)  as gn by department

Now ,I want to get a column to show values which count >=2

For example :
there have two "Model List" . I want to show it in another column

Please help me

alt text

0 Karma
1 Solution

thambisetty
SplunkTrust
SplunkTrust

| eventstats count by oper_field ,department| where count > 1 | stats list(oper_field) as gn by department

————————————
If this helps, give a like below.

View solution in original post

thambisetty
SplunkTrust
SplunkTrust

| eventstats count by oper_field ,department| where count > 1 | stats list(oper_field) as gn by department

————————————
If this helps, give a like below.

WXY
Path Finder

what do you need me to offer you, my data or a sample of the results is shown ?

0 Karma

thambisetty
SplunkTrust
SplunkTrust

Sample input and output

————————————
If this helps, give a like below.
0 Karma

WXY
Path Finder

Thank you!
Now I have another question,can you help me?
I want get data which accounted for the largest proportion . such as ,there are two "Model List" ,and all of data are three, the "Model List" is the largest proportion,what should I do?

0 Karma

thambisetty
SplunkTrust
SplunkTrust

Can you give me an example?

————————————
If this helps, give a like below.
0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...