Duplicate Mac address for a single computer

[Mehdi]

Hello, I have several entries in duplicate mac adresse, here is an example, for one of my computers :
How can I delete the entry of 06/04/2011 which is an old record ?
Tanks


Carte AMD PCNET Family Ethernet PCI - Miniport d'ordonnancement de paquets

192.168.0.27

00:50:56:A0:52:35

True

192.168.0.1

192.168.0.11 , 192.168.0.220

255.255.255.0

12/05/2012

Carte AMD PCNET Family Ethernet PCI - Miniport d'ordonnancement de paquets

192.168.0.27

00:50:56:A0:52:35

True

192.168.0.1



255.255.255.0

06/04/2011

[Hemoco]

We created an updated version of this report a while back, which should be more accurate. Please try the report below.

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

[Mehdi]

I want to remove the duplicate entry from the report.
Tanks

[Hemoco]

Could you clarify whether you want to remove the computer from the report or remove the computer from your database altogether.