FQDN name remote machine

[nagendra]

need to find FQDN Name for the list of IP's

example i have around 2000's IP's where 1000 IP's are in .XXX domain and few are .SSS domain ..

we can find in AD but few are offline and few are not accessible. so i thought in LANSWEEPER we can find the FQDN Name..

[muehterc]

Is there a way to separate by server or workstation? i'm not great at select statements.

[nagendra]

Thanks its working...

[Bruce_B · Accepted solution]

The FQDN of an asset, if found, is stored in the field tblAssets.FQDN. The report below lists the FQDN information in your Lansweeper database regarding your assets. Instructions for adding this report to your Lansweeper installation can be found here.
If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.FQDN,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.FQDN Is Not Null And tblAssets.FQDN != ''