List Server with IP/Subnet/DNS Servers

[dtsteinb]

I am looking for a report that will show me my servers along with their IP, Subnet and DNS servers used.

[dtsteinb]

Thanks for this. Great help.

[Susan_A · Accepted solution]

I've included a sample report below.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress As LastScannedIP,
  tsysIPLocations.IPLocation As CurrentIPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblNetwork.Description As Adapter,
  tblNetwork.IPAddress,
  tblNetwork.IPSubnet,
  tblNetwork.DNSServerSearchOrder
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
    And tsysIPLocations.EndIP >= tblAssets.IPNumeric
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
  tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Adapter