Getting Data In

Analyse Apache Other Vhosts Access Log

New Member

Hello, I am new to splunk, wondering if you could help me please, I am trying to analyse my vhosts access log.

the format is:

somedomain.com:80 123.123.123.123 - - [13/Sep/2013:02:15:21 +0000] "POST /wp-login.php HTTP/1.1" 200 1904 "some url here" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0"

I was able to graph by the vhost (somedomain.com) value, and by the bytes separately
but I would like to see bytes per vhost, could you please advise how could I do this?
Thank you very much, sofar splunk looks very robust and exciting...

0 Karma
1 Solution

Builder

Hi Moonpixel,

Welcome to Splunk! If I had to guess, something like this might work:

<base search> | stats sum(bytes) AS total_bytes by vhost

Let me know how you go 🙂

View solution in original post

0 Karma

Builder

Hi Moonpixel,

Welcome to Splunk! If I had to guess, something like this might work:

<base search> | stats sum(bytes) AS total_bytes by vhost

Let me know how you go 🙂

View solution in original post

0 Karma

New Member

fantastic, thank you, this is exactly what I was looking for...

source="/.../othervhostsaccess.log" | stats sum(scbytes) AS totalbytes by s_sitename

0 Karma

Builder

Hi Moonpixel - Can you share the search queries you used to generate your successful results? Knowing that will help get you an answer 🙂

0 Karma