‎04-09-2015 07:59 AM
Solved! Go to Solution.
‎04-09-2015 10:20 AM
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Mac As MainMAC,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSNMPInfo.IfMacaddress As NICMAC
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
Where tsysAssetTypes.AssetTypename = 'printer' And
tblSNMPInfo.IfMacaddress Is Not Null And tblSNMPInfo.IfMacaddress <> '' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
NICMAC
‎04-10-2015 04:25 PM
‎04-09-2015 10:29 AM
‎04-09-2015 10:20 AM
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Mac As MainMAC,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSNMPInfo.IfMacaddress As NICMAC
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
Where tsysAssetTypes.AssetTypename = 'printer' And
tblSNMPInfo.IfMacaddress Is Not Null And tblSNMPInfo.IfMacaddress <> '' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
NICMAC
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now