Discover Workstations or Server with Only 1 DNS
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