KACE reporting incorrect MAC addresses
Hello all. Our KACE is showing 78 devices with the same mac address. I cannot figure out why. When I do an ipconfig /all, the machines show their true MAC address. Why would 78 out of 200 devices show the same MAC address when at least the ones I have checked show a completely different MAC. I am not even sure where that MAC address came from.
2/16/2018 update: I had a web-ex session with Quest Support and found that in the inventory xml file, every network adapter is listed with the one listed at the top as primary. So, on our devices showing the same MAC address, they all have RAS Async Adapter listed as the primary netowk device. I have been searching online for two hours trying to figure out what this is and how I can disable it. I believe it may have something to do with remote access to the computer, but I cannot confirm that. I seriously have no clue exactly what this is and how to demote it or turn it off. Is anyone familiar with RAS Async Adapter on Windows 7?
7 Comments
[ + ] Show comments
Answers (0)
Answer Summary:
Please log in to answer
SELECT
A.ID AS AID,
A.ASSET_TYPE_ID AS ATID,
A.NAME AS ANAME,
M.NAME AS MNAME,
AD5.FIELD_10003 AS SERIALNUMBER,
AD5.FIELD_10011 AS AOS,
M.OS_NAME AS MOS,
AD5.FIELD_10008 AS AMANUFACTURER,
M.CS_MANUFACTURER AS MMANUFACTURER,
AD5.FIELD_10012 AS AIP,
M.IP AS MIP,
AD5.FIELD_10013 AS AMAC,
M.MAC AS MMAC
FROM MACHINE M, ASSET A, ASSET_DATA_5 AD5
WHERE A.NAME = M.NAME
AND A.ASSET_DATA_ID = AD5.ID
ORDER BY AD5.ID
The MAC address in the Machine table (Inventory) is directly from the agent on the device and that is where the information is incorrect. So I am not sure how to correct it since it is not editable as far as I can tell. - jessburd 6 years ago
SELECT NAME, MAC FROM MACHINE
are they all the same then? - chucksteel 6 years ago
An interesting tidbit is that they are all windows 7 computers. None of our Windows 10 computers are showing this odd MAC and not all Windows 7 computers are showing it. But all that do show it are WIN 7.
My rule to set the asset information regarding the MAC address is as follows (It doesn't hurt to have another set of eyes see this again but like you, I don;t think it is likely as over 100 computers are correct in KACE as far as I can tell):
SELECT AD5.ID
FROM ASSET_DATA_5 AD5
JOIN ASSET on ASSET.Asset_Data_ID = AD5.ID and ASSET.ASSET_TYPE_ID = 5
JOIN MACHINE on MACHINE.ID = ASSET.MAPPED_ID
WHERE AD5.FIELD_10013 != MACHINE.MAC
UPDATE ASSET_DATA_5
set FIELD_10013 = (select
MACHINE.MAC
FROM ASSET
JOIN MACHINE on MACHINE.ID = ASSET.MAPPED_ID
where ASSET.ASSET_DATA_ID = ASSET_DATA_5.ID and ASSET.ASSET_TYPE_ID = 5)
where ID in (<TICKET_IDS>) - jessburd 6 years ago
At the moment, I do not have access yet to select "Don't allow connections to this computer" under the Remote tab in system properties so I cannot disable it on the computer that I am testing (the user is out of the office so I have free reign at the moment).
So, is anyone familiar with RAS Async Adapter on Windows 7? - jessburd 6 years ago
I was told "the defect id is K1-19884."
The problem is that the KACE Agent grabs the first IP from the list of different adapters that are installed on the local machine.
This has the potential of grabbing the Wireless, BT or any other adapter. I have about 8 on my Dell laptop. - IDeLeon007 4 years ago