Splunk Search

Why doesn't my base search query work?

lsy9891
Engager

I wrote this base search query:

host=NETWEBA* sourcetype="WinEventLog:Application" AND ApplicationSource="/jpw*" AND "ErrorGUID" | fields OuterExceptionType

And I extended this query to get the top 5 exceptions

stats count by OuterExceptionType  AS "Outer_Exception_Type"| sort - "Outer_Exception_Type"

But it returns no results whereas if I don't use a base search it works fine?

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@lsy9891

Not sure about field name changing but can you please try this?

stats count by OuterExceptionType  | sort - OuterExceptionType  

OR

stats count by OuterExceptionType  | sort - OuterExceptionType  | rename OuterExceptionType as  "Outer_Exception_Type"
0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...