Report on all DNS related scanning errors within Lansweeper and identify devices that require your attention. DNS related issues can prevent Lansweeper from scanning assets. Some scanning methods rely on name resolution before they can start a scan. This report provides an overview of all assets which have had a DNS scanning error. This allows you to find which assets might be having DNS issues and should be looked at. Once resolved, Lansweeper can resume scanning and updating your inventory data.
DNS Error Query
Select Top 1000000 tblErrors.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblErrors.ErrorText,
Max(tblErrors.Lastchanged) As [Last changed]
From tblErrors
Inner Join tblAssets On tblErrors.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Group By tblErrors.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblErrors.ErrorText
Having tblErrors.ErrorText Like '%dns redirected%'
Order By [Last changed] Desc
