cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
nagendra
Engaged Sweeper II
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..

1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
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 != ''

View solution in original post

3 REPLIES 3
muehterc
Engaged Sweeper
Is there a way to separate by server or workstation? i'm not great at select statements.
nagendra
Engaged Sweeper II
Thanks its working...
Bruce_B
Lansweeper Alumni
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 != ''