topic Re: Traffic Report: How much destination hosts contacted in General Topics

Traffic Report: How much destination hosts contacted

Sat, 16 Feb 2013 21:22:48 GMT

Hi Community!

There is a predefined traffic report "Connections": It shows per row how much connections (sessions) a source host has made to a specific destination host.

Is it possible to create a report which shows per row how much distinct destination hosts a source host has contacted? This could be useful for example to recognize if a source host is scanning a lot of different destinations.

Let me explain it further.

The "Connections" report shows:

Source Host	Destination Host	Sessions
SrcA	DstA	50
SrcB	DstB	40
SrcA	DstC	30
SrcB	DstA	20
SrcB	DstD	10

I was trying to create a report like this:

Source Host	Destination Hosts Contacted
SrcB	3
SrcA	2

Do you think this is possible?

Is there a way to query the database(s) in the PA directly (via SQL)?

Thanks in advance!

Model: PA-5020

Software version: 5.0.2

Re: Traffic Report: How much destination hosts contacted

ericgearhart — Sun, 17 Feb 2013 02:23:47 GMT

I'm not sure if the API specifically reports on session information, but there is a PAN API that exposes a bunch of information. Here's an overview:

Also here is the XML API documentation:

I'm betting that what you're requesting is possible with the API... possibly combined with a custom report built on the firewall and then 'pulling' that report via the API

Re: Traffic Report: How much destination hosts contacted

Sun, 17 Feb 2013 19:40:03 GMT

Dear egearhart!

I followed your advice and browsed the REST API.

There are three types of reports you can get with it:

Dynamic Reports: They are predefined and you can only set the timeframe and the number of rows. There is no connection report or the like.
Predefined Reports: These are the same predefined reports you can via the web page, including the top-connections report i mentioned.
Custom Reports: You can get retrieve the results of custom reports. But you have to create this report on the webpage.

I also could not find a way to query the traffic databases on the PA with SQL via the REST API.

So the question still persists: Has someone an idea how to create a custom report which counts the destination hosts a source host contacted?

Otherwise the only way to create such a report would be to retrieve the traffic log of the last day somehow, feed it into a database (such as MySQL) and do the queries there.

Since 5.0.0 you can retrieve logs via REST API. But there is a maximum of 5000 rows. Is there another way?