Discover all machines within your network that only have one DNS server specified. Usually, workstations and servers have a primary and secondary DNS server for redundancy in case one DNS server goes down. When a computer only has one DNS server, and that DNS server goes down, browsing and other network related tasks that rely on name resolution will not work. It is, therefore, it is important that a secondary DNS server is set so that users or servers never have issues.
By performing the audit you can quickly identify assets that need a secondary DNS server and take action.
Only 1 DNS Server Audit Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon,
tblNetwork.DNSServerSearchOrder As [DNS server],
tblNetwork.IPAddress,
tblNetwork.IPSubnet,
tblNetwork.Lastchanged
From tblAssets
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where Not (tblNetwork.DNSServerSearchOrder Like '%,%') And
tblNetwork.DNSServerSearchOrder <> '' And tblNetwork.IPAddress <> '0.0.0.0'
And tblNetwork.IPAddress <> '' And tblNetwork.IPEnabled = 1 And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
