Device network history is stored in tblNetworkHist. Unfortunately history tracking for the item "Network" isn't enabled by default so it is highly possible that this table is not populated for you. You can enable history tracking for specific items under Scanning\Scanned Item Interval, do note that this won't work retroactively. If you did have it enabled you can filter for the laptop in the output of the report below to get all its "old" MAC addresses. You can add this report to your Lansweeper installation by following
these instructions.
If you didn't have network history tracking enabled, you could potentially
restore an older backup of your Lansweeper database into a test environment to retrieve this information.
Your new laptop asset will indeed have overwritten the old one if it had the exact same Domain Netbios/Assetname Netbios combination, as explained in
this article.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblNetworkHist.MACaddress As [Old MAC addresses]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblNetworkHist On tblAssets.AssetID = tblNetworkHist.AssetID
Where tblAssetCustom.State = 1