How to Create a Custom Report for Traffic Log with Non-US Destinations

Overview

This document describes how to create a query to exclude non-US destinations from a traffic log custom report.

Steps

1. Go to Monitor > Manage Custom Reports
2. Click Add.
3. For the Database, select "Traffic Log" under the "Detailed Logs (Slower)" section in the drop-down.
4. Select columns as desired.
5. In the Query Builder, include the following query: dstloc neq US
   Note: The Destination Country attribute is not available in the Query Builder, so the query must be entered manually. Please refer to the example.
   

Examples

With the Query Builder configured to exclude US:

With the Query Builder left empty (no filters specified):

owner: kadak