I've created a duplicate MAC address report based on one of the suggestions here.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Mac,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.LastChanged
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Mac <> '' And (Select Count(*) From tblAssets As a
Where a.Mac = tblAssets.Mac) > 1
Order By tblAssets.Mac
Some of the results show computers that don't report the address listed in the report.
I.e
Computer MAC
PC001 00:11:22:33:44:55
iPhone01 00:11:22:33:44:55
If i click on PC001 I can't find any network adaptors, modems or other devices that have that MAC address.
Is there something wrong with the report, or am I missing something?
