Asset MAC address history

[AlexK]

Hi community,
Is there a way to see the MAC address history for asset? asset = laptop, that been replaced with new one with same netbios name, so all old laptop data has been replaced with data from new laptop. Old laptop has been stolen and police is asking for MAC-address of this laptop 😃

[Bruce_B · Accepted solution]

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