cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lstejay
Engaged Sweeper
Hi Forum,

when I run the report Computer: Duplicate MAC addresses
there are 100+ entries.

First of all there are many "known" duplicates, like these two:
VMware Virtual Ethernet Adapter for VMnet1 00:50:56:C0:00:01
VMware Virtual Ethernet Adapter for VMnet8 00:50:56:C0:00:08
or these ones:
VPN Adapter - Miniport xx:55:43:44:xx:xx
F5521gw Mobile Broadband Driver 02:80:xx:xx:xx:xx

Is there a configuration entry to skip these known mac addresses or
known network adapters?

Second, there are duplicate Mac Adresses listed from the same client,
i.e. a tablet pc running win xp:
Paketplaner-Miniport 00:18:82:01:xx:D0
Wireless Intermediate Drive 00:18:82:01:xx:D0
Paketplaner-Miniport 00:18:82:01:xx:AA
Wireless Intermediate Drive 00:18:82:01:xx:AA
Paketplaner-Miniport 00:15:93:01:xx:EF
Wireless Intermediate Drive 00:15:93:01:xx:EF
Paketplaner-Miniport 00:05:71:01:xx:D1
Wireless Intermediate Drive 00:05:71:01:xx:D1

Is this a bug or a feature?

TIA, Thomas
1 REPLY 1
Hemoco
Lansweeper Alumni
This report will be updated for Lansweeper 5.0. For 4.2, you can update the report to the one below. It only lists duplicates that occur across multiple machines.

Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, tblComputers.Computer,
Web40OSName.OSname As OS, tblOperatingsystem.Description,
Duplicates.MACaddress, Duplicates.Total, tblComputers.Lastseen,
Web40OSName.Compimage As icon
From tblComputers Inner Join
web40ActiveComputers On web40ActiveComputers.Computername =
tblComputers.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername Inner Join
(Select Top 1000000 tblNetwork.MACaddress, Count(Distinct
tblNetwork.Computername) As Total
From tblComputers Inner Join
web40ActiveComputers On web40ActiveComputers.Computername =
tblComputers.Computername Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where tblNetwork.IPEnabled = 1
Group By tblNetwork.MACaddress
Having (tblNetwork.MACaddress <> '' And tblNetwork.MACaddress <>
'50:50:54:50:30:30' And tblNetwork.MACaddress <> '33:50:6F:45:30:30') And
Count(Distinct tblNetwork.Computername) > 1) Duplicates On
tblNetwork.MACaddress = Duplicates.MACaddress
Order By Duplicates.Total Desc, Duplicates.MACaddress, tblComputers.Computer

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now