Splunk Enterprise

Timechart Count by multiple regexed fields

neill_freer
New Member

I'm trying to create a timechart that tracks the total count of 3 different areas of error per day. I've regexed out each type which works fine, but I cannot get a timechart to work at all.

This is my current splunk search:

host="hostname" sourcetype=sourcetypename "[ERROR]" | rex field=_raw "\.php\:\d+\n(?P<StackTraceError>.*)\:\n" | rex field=_raw "\\\LdapServiceProvider\:\:(?P<IncorrectUsernameOrPassword>.+)\s" | rex field=_raw "\s\-\sTraceyId\:\"(?P<AppError>.+)\-\d.+\"\s\-\-"

Any ideas?

Tags (1)
0 Karma

DalJeanis
Legend

Try this...

 host="hostname" sourcetype=sourcetypename "[ERROR]" 
| rex field=_raw "\.php\:\d+\n(?P<StackTraceError>.*)\:\n" 
| rex field=_raw "\\\LdapServiceProvider\:\:(?P<IncorrectUsernameOrPassword>.+)\s" 
| rex field=_raw "\s\-\sTraceyId\:\"(?P<AppError>.+)\-\d.+\"\s\-\-"
| bin _time span=1m
| stats count(StackTraceError) as StackTraceError count(IncorrectUsernameOrPassword) as IncorrectUsernameOrPassword count(AppError) as AppError by _time
| untable _time errortype errorcount
| timechart sum(errorcount) as errorcount by errortype 
0 Karma

niketn
Legend

What is the issue you are facing with timechart? What is the timechart query you are running?

Are you able to display values in table using

 | head 10 
 | table _time StackTraceError IncorrectUserNameOrPassword AppError
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Unlock Database Monitoring with Splunk Observability Cloud

In today’s fast-paced digital landscape, even minor database slowdowns can disrupt user experiences and stall ...

Print, Leak, Repeat: UEBA Insider Threats You Can't Ignore

Are you ready to uncover the threats hiding in plain sight? Join us for "Print, Leak, Repeat: UEBA Insider ...

Splunk MCP & Agentic AI: Machine Data Without Limits

  Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization ...