Report Showing Servers Using a Specific DNS Server

[Intheory87]

Anyone know if there is a way to return a report that will show are servers that are using a specific DNS server?

[Susan_A · Accepted solution]

A sample report can be seen below. Replace what's marked in yellow with your own DNS server name. Instructions for running reports can be found here. For future report requests, please review these resources first.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblNetwork.Description As NIC,
  tblNetwork.DNSServerSearchOrder
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblNetwork.DNSServerSearchOrder Like '%192.168.1.1%' And
  tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
  tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  NIC