PC mac address conflict

[abolus]

hi can you please help me. i a m trying to extract a report from lan sweeper that will give me a PC name and a Mac Address of the PC but when i open the database it gives me a different MAC address. see attached file.

you can see it on the highlighted part of the query. it is giving different mac. but the PC did not change since before.

correct pc mac is 70:f3:95:0d:66:61

other mac address i do not know where it came from?... we did not change the anything on the PC. please advise

[abolus]

ok thanks it works

[Hemoco]

Filter on field "ipenabled"

Select Top 1000000 dbo.tblComputers.Computername, tblNetwork.IPEnabled,
tblNetwork.Description, tblNetwork.MACaddress
From dbo.tblComputers Inner Join
tblNetwork On dbo.tblComputers.Computername = tblNetwork.Computername
Where tblNetwork.IPEnabled = 1

[abolus]

how can i get the correct mac address that is shown in the web console? i need to generate a report.

cpmputer name is 12827
correct mac is 70:f3:95:0d:66:61

[Hemoco]

your query is correct but it shows the mac addresses for all network cards in the computer (physical or virtual)

[abolus]

simply just this one.
-----------
SELECT Computername, MACaddress, Lastchanged, NetworkID
FROM tblNetwork
order by Computername
-------------------


if i want to get the maxrecord for networkid so that i can get the latest mac here is the sql
-----------------
SELECT tblComputers.FQDN, a.Computername, a.MACaddress, a.Lastchanged, a.NetworkID
FROM tblNetwork AS a INNER JOIN
tblComputers ON a.Computername = tblComputers.Computername
WHERE (a.NetworkID =
(SELECT MAX(NetworkID) AS Expr1
FROM tblNetwork AS b
WHERE (a.Computername = Computername)))
ORDER BY a.Computername
------------------

[Hemoco]

Can you also post the sql of this query please.