Getting Data In

How to search with regex and status count to show in a table?

Wendy
Explorer

Hi, need some help in crafting a search query that could get count by a regex and display counts in a table.

 

The log msg we have is "Successfully submitted: admin-mobile" or "Successfully submitted: admin". I'd like to count numbers of msg contains "admin-mobile" and "admin" respectively and show them in a table.

 

I know that I can get one count by:

`| search "Successfully submitted: admin-mobile" | stats count` and it will show in a table. 

Question is how to get the other count. Thanks.

 

The result i'd like to have is like below, in a table format:

submissionType        count   

admin-mobile              999

admin                              888

Labels (1)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

Use

your_search... "Successfully submitted: admin*" 
| rex "Successfully submitted: (?<user>[\w-]+)"
| stats count by user

your rex regex will be dependent on what you want to extract and what may follow user name, but the above will take user from the words following the Successfully submitted message.

0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...