Splunk Search

How to fetch results by grouping the fields with a condition like count>0?

iamsgsn
New Member

Hi Team,

I have fields like txn_id and txn_chain_id where txn_chain_id can have more than 1 txn_id like:

Log 1: .....txn_id=100 txn_chain_id=1000
Log 2: .....txn_id=101 txn_chain_id=1000
Log 3: .....txn_id=102 txn_chain_id=1000
Log 4: .....txn_id=201 txn_chain_id=2000
Log 5: .....txn_id=202 txn_chain_id=2000

And so on.

I wish to write a search which gives me output as below, dynamically pulling all the txn_chain_ids having txn_ids > 1.

txn_chain_id              count(txn_id)
1000                           3
2000                           2

Can someone help me getting the search?
Please do the needful.

0 Karma
1 Solution

somesoni2
Revered Legend

Try this

your base search |  stats dc(txt_id) as "count of txn_id" by txn_chain_id

View solution in original post

somesoni2
Revered Legend

Try this

your base search |  stats dc(txt_id) as "count of txn_id" by txn_chain_id

iamsgsn
New Member

Thanks. It worked.

0 Karma

somesoni2
Revered Legend

Great.. Please close the question by clicking on the Accept.

0 Karma
Get Updates on the Splunk Community!

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...