‎10-06-2015 03:28 PM
Solved! Go to Solution.
‎10-07-2015 04:55 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.Image As icon,
tsysOS.OSname,
tblNetwork.Description As [Network interface],
tblNetwork.IPAddress As IPAddresses
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblNetwork.IPAddress Like '%:%' And tblAssetCustom.State = 1 And
tblNetwork.IPEnabled = 1
Order By tblAssets.AssetName,
[Network interface]
‎02-05-2019 08:36 PM
‎10-07-2015 05:37 PM
‎10-07-2015 04:55 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.Image As icon,
tsysOS.OSname,
tblNetwork.Description As [Network interface],
tblNetwork.IPAddress As IPAddresses
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblNetwork.IPAddress Like '%:%' And tblAssetCustom.State = 1 And
tblNetwork.IPEnabled = 1
Order By tblAssets.AssetName,
[Network interface]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now