report for CVE june vulnerability

[nikhilbalaji]

Can someone help me to get a audit query for listing only DNS servers checking CVE june vulnerability

[Bruce_B]

You can filter for DNS servers in your report by doing the following:

Join the tables containing service data:

INNER JOIN tblServices ON tblServices.AssetID = tblAssets.AssetID
INNER JOIN tblServicesUni ON tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID

Add a check for the DNS Server service in your Where clause:

WHERE tblServicesUni.Caption LIKE '%DNS Server%'
AND tblServices.Started = 1

[nikhilbalaji]

Thanks FrankSc. I ran this query but it is pulling out report from all workstations and servers. Is there any way I can get report for only dns servers

[FrankSc]

Hello,

This is part of our July 2020 a patch Tuesday report for which you can find a link on the blog post below:
https://www.lansweeper.com/patch-tuesday/microsoft-patch-tuesday-audit-july-2020/