Tableau Server: Get Bytes

Continuing the Log Analytics theme for Tableau Server, specifically the ‘Monitor’ pillar of A.I.M., it’s time to show another quick tip for analyzing your Apache logs. Understanding how much data is moving through the wire is another technique one could use to decide whether dashboards, CSVs or general crosstab download needs to be optimized. I shouldn’t need to mention it’s also a great way to monitor the security and integrity of your data.

apache-bytes-0
The ‘Alert’portion. If something is outside the norm, we’re alerted. 

We’ll use the module I loaded here to do the heavy lifting. Once you export a csv, load into Tableau for some analysis (or perhaps mash it up with the geo dashboard I demoed a while back).

You’ll want to pass this query for the ‘leFilter’ section: ‘/HTTP\/1\.1″ “-” \d{3}\s(?P<size>\d*)/ AND size>1000000’

The idea is that, over time, you’ll be able to see what is being requested with the most amount of bytes and, potentially, a better way to optimize your content. Further, it’s a fantastic way to be alerted (‘Alert’ portion of A.I.M.) on large (consistent) GET requests from questionable sources.

In the end, this all fits together with time-to-serve data and other performance and security related inputs.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s