‎03-09-2018 03:21 PM
Solved! Go to Solution.
‎03-12-2018 03:37 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssetCustom.Location,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblSNMPAssetMac.AssetMacAddress,
tblAssets_1.AssetName As Switch,
tblSNMPInfo.IfIndex As Port,
tblAssets.Description,
tblAssets.Lastseen
From tsysAssetTypes
Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetMacAddress
On tblAssets.AssetID = tblAssetMacAddress.AssetID
Inner Join tblSNMPAssetMac On tblAssetMacAddress.Mac =
tblSNMPAssetMac.AssetMacAddress
Inner Join tblSNMPInfo On tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex And
tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID
Inner Join tblAssets tblAssets_1 On tblSNMPInfo.AssetID = tblAssets_1.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Order By tblAssets.AssetName
‎03-16-2018 12:59 PM
‎03-12-2018 03:37 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssetCustom.Location,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblSNMPAssetMac.AssetMacAddress,
tblAssets_1.AssetName As Switch,
tblSNMPInfo.IfIndex As Port,
tblAssets.Description,
tblAssets.Lastseen
From tsysAssetTypes
Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetMacAddress
On tblAssets.AssetID = tblAssetMacAddress.AssetID
Inner Join tblSNMPAssetMac On tblAssetMacAddress.Mac =
tblSNMPAssetMac.AssetMacAddress
Inner Join tblSNMPInfo On tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex And
tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID
Inner Join tblAssets tblAssets_1 On tblSNMPInfo.AssetID = tblAssets_1.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now