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!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...