Is there a way to create a filtered report based on specific countries?

[hvcomputech]

On PA 4.1.

I have a custom report that uses the traffic log database, with the top 500 entries for the last calendar day, with the Destination Country column enabled. 95% of the Destination Country results is the USA. I'm interested in looking at traffic to other countries. Is there a way to create a recurring report that will filter out the USA so the destination countries are other than the USA?

Thanks.

[Jamiefitzgerald]

To create a report for all traffic that is not from the US, add the following filter to the query builder:

( dstloc neq US )

[hvcomputech]

Awesome, it works!

Where can we find a list of useful 'nuggets' such as dstloc?

Thanks.

[Jamiefitzgerald]

Glad it worked out. 

A lot of these nuggets are on this forum, but I will see if I can find a "management nuggets" document or create one.

[bmaslakovic]

This is very useful, has this list been found/made? If so can you send me an email?

[mikand]

The boring answer is that it exists at page 384 in the PAN-OS_4.1_CLI_Reference_Guide.pdf

[Jamiefitzgerald]

Mikand has a good point when it comes to logs and show commands.  I might have a few other nuggets to share.  Once I have a chance to capture some of these, I will email them and post them.  Thank you,

~Jamie

[qstackfield1]

Has a list of these "Mgmt_Nuggets" been created yet?