topic Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type? in General Topics

How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

Maxstr — Fri, 17 Feb 2017 17:18:16 GMT

I have a report that shows any traffic that hits my DNS Sinkhole rule, but it doesn't show what the URL was or if it was spyware. I want to add the URL or the threat type (spyware/virus) to the sinkhole report.

Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

sullivanpj2 — Fri, 17 Feb 2017 19:28:08 GMT

This might be helpful.. but not 100% sure since I don't have a lab box in front of me.

https://live.paloaltonetworks.com/t5/Learning-Articles/How-to-Create-a-Custom-Report-for-Suspicious-DNS-Queries/ta-p/61082

Bottom of this one shows a custom report with action sinkhole and threat logs.

https://live.paloaltonetworks.com/t5/Configuration-Articles/How-to-Deal-with-Conficker-using-DNS-Sinkhole/ta-p/52920

- Peter

Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

Maxstr — Fri, 17 Feb 2017 20:05:48 GMT

That's how I have it set up now, but all it shows is the source of the DNS query. But it doesn't show the URL or type of threat

Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

santonic — Tue, 21 Feb 2017 08:17:40 GMT

The IP and URL of infected client would be seen in 'Suspicious DNS queries' events. But I guess in your case the source IP of DNS query is of DNS server which other hosts are using?

In that case PA doesn't have an association which client asked for which URL so you won't be able to achieve this just on PA. However the idea of DNS sinkhole is to identify infected hosts and i would say it doesn't really matter with what are they infected, you just want to clean them and stop them appearing in any threat logs 🙂

Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

Maxstr — Tue, 21 Feb 2017 15:30:56 GMT

I absolutely agree, but the reason I asked is because I need to create a report that shows proof that this desktop is attempting to talk to malicious domains. I have public wifi on my network, so the desktop's IP changes and User-ID does not work if the machine connects to the public wifi network. So the only way I can tell it's the same machine is if they are both accessing identical URL's

Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

santonic — Wed, 22 Feb 2017 07:21:13 GMT

Well if it's accessing the IP assigned by DNS sinkhole then it's certainly trying to connect to malicious domain. No other reason to access that IP.

And the DNS query is part of C&C traffic so time betwen DNS query and actual (http) connection to C&C server is less than a second so no chance of IP changing in between.

Re: How do I create a custom report for a DNS sinkhole that will show the URL or threat type?

Maxstr — Wed, 22 Feb 2017 14:36:25 GMT

The reason I am looking for reports is because I need something to show to management regarding an outside vendor machine that I have no control over.

But this wouldn't even be an issue if I could just create reports from the Correlation log.