Splunk Search

Difference in Queries

koushiknandan
New Member

Hi,

Though I'm receiving the same output for both my queries, curious to know the difference (executions, time taken, etc) between them.
The bold part is the only change.

index=PD host=ABC* uri="/XXXX" AND (http_status="200" OR http_status="500") | convert timeformat="%Y-%m-%d" ctime(_time) AS Date | stats count(eval(http_status="200")) as "HTTP 200", count(eval(http_status="500")) as "HTTP 500" by Date

index=PD host=ABC* uri="/XXXX" | convert timeformat="%Y-%m-%d" ctime(_time) AS Date | stats count(eval(http_status="200")) as "HTTP 200", count(eval(http_status="500")) as "HTTP 500" by Date

Thanks

Tags (2)
0 Karma
1 Solution

wpreston
Motivator

Splunk gives the kind of information you're looking for in the job inspector. Take a look at it for each of your searches by clicking job --> inspect job and see if it has what you need.

View solution in original post

0 Karma

wpreston
Motivator

Splunk gives the kind of information you're looking for in the job inspector. Take a look at it for each of your searches by clicking job --> inspect job and see if it has what you need.

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...