‎04-21-2015 04:55 PM
‎04-24-2017 06:59 PM
Select Top 1000000 tblAssets.AssetUnique,
tblAssets.IPAddress,
tblAssets.AssetName,
tblSNMPAssetMac.AssetMacAddress As [Reported Mac],
tblAssetMacAddress.Mac As [Actual MAC],
tblSNMPAssetMac.SNMPMacID,
tblSNMPAssetMac.Lastchanged
From tblSNMPAssetMac
Inner Join tblAssets On tblSNMPAssetMac.AssetMacAddress = tblAssets.Mac
Inner Join tblAssetMacAddress
On tblAssets.AssetID = tblAssetMacAddress.AssetID
‎08-12-2016 09:28 PM
‎07-23-2015 11:59 PM
‎07-07-2015 04:50 PM
‎07-06-2015 09:16 PM
‎07-02-2015 08:32 AM
Delete tblSNMPAssetMac
FROM tblSNMPAssetMac
Inner Join tblSNMPAssetMac As t2 On tblSNMPAssetMac.AssetMacAddress = t2.AssetMacAddress
And tblSNMPAssetMac.LastSeen < t2.LastSeen And tblSNMPAssetMac.AssetMacAddress = t2.AssetMacAddress
‎06-30-2015 01:17 AM
Select Distinct Top 1000000 t1.*
From tblSNMPAssetMac As t1
Inner Join tblSNMPAssetMac As t2 On t1.AssetMacAddress = t2.AssetMacAddress
And t1.LastSeen < t2.LastSeen And t1.AssetMacAddress = t2.AssetMacAddress
Select Distinct Top 1000000 t1.*
From tblSNMPAssetMac As t1
Inner Join tblSNMPAssetMac As t2 On t1.AssetMacAddress = t2.AssetMacAddress
And t1.SNMPMacID <> t2.SNMPMacID And t1.AssetMacAddress = t2.AssetMacAddress
‎06-29-2015 09:20 PM
‎04-28-2015 11:32 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now