topic Re: Line graph of URL hits based on http code over time in Splunk Search

Line graph of URL hits based on http code over time

nirmalya2006 — Mon, 25 Jul 2016 13:50:46 GMT

Hi All

I have 2 fields extracted -
URL as page and HTTP Response code as ResponseCode
I want to created a chart having multiple lines, each line showing the count of each different URLs having response code 200 over a period of time, maybe hourly or daily.
How can I create the query for that.

I did the below query

| chart count over ResponseCode by page usenull=f useother=f | where ResponseCode = 200

But I am unable to fit in the _time in the query to chart it in the x-axis.
Can someone help me to get _time in x-axis and show the count of 200 ResponseCodes based on the multiple pages

Thanks

Re: Line graph of URL hits based on http code over time

sundareshr — Mon, 25 Jul 2016 14:05:41 GMT

Try this.

... | where ResponseCode = 200 | timechart span=1h count by page limit=0

Re: Line graph of URL hits based on http code over time

nirmalya2006 — Mon, 25 Jul 2016 16:16:51 GMT

This helped not only the one in the question, but another of my query also.
Thank you very much..