
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblNetwork.DNSServerSearchOrder As DNSserver,
tblNetwork.IPAddress As NetworkIPAddress,
tblNetwork.IPSubnet,
tblNetwork.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblState.Statename = 'Active' And tblNetwork.IPAddress <> '0.0.0.0' And
tblNetwork.IPAddress <> '' And tblNetwork.IPEnabled = 'True' And
tblNetwork.DNSServerSearchOrder Like '%109.234.35.230%' Or tblNetwork.DNSServerSearchOrder Like '%94.103.82.249%'
Order By tblAssets.AssetName,
tblAssets.Domain,
DNSserver
Explore the full platform, free for 14 days.
No credit card required.