If the computers have already connected via a VPN, create a new entry in the ePOVirtualMacVendor table with the Organization Unique Identifier (OUI), which is part of the VPN MAC address:
- Determine the VPN MAC address to add to the ePO VendorID field:
The best way to obtain the VPN MAC address is to identify a computer that has connected to the ePO server for the first time via VPN and removed the previous computer.
-
From the client, use the agent Status Monitor to Collect and Send Props.
-
Log on to the ePO console.
-
Click Systems.
-
Click the System Tree.
-
Locate the computer that has connected via VPN.
-
Double-click on the computer to view its properties.
-
To the right of System Information, click More. You see the VPN MAC address collected from the client.
-
Scroll down and locate the MAC Address. Make a note of the first six digits of this MAC address in the next step (for example, 00123F21ECED).
If you cannot identify a computer using the virtual MAC, you can author a report to identify the computers:
- Log on to the ePO console.
- Click Menu, Reporting, Queries.
- Click New Query.
- Click System Management, Managed Systems and click Next.
- Select Single Group Summary Table for Display Results As.
- In the Labels Are: drop-down list, select MAC Address under Computer Properties, click Next, and then click Next again.
- Click Managed State under Managed Systems, select Equals from the Comparison drop-down list, and select Managed from the Value drop-down list.
- Click Run.
You now have a list of MAC addresses with a count of the number of systems reporting that MAC address. Ideally it would be a one-to-one ratio. If you have more than one system sharing the same MAC address, that is probably your issue.
- Modify the SQL script to add the computer to the tree:
NOTE: For more information about running SQL scripts provided by Technical Support using OSQL for ePO, see
KB67591.
The referenced article is available only to registered ServicePortal users.
To view registered articles:
- Log on to the ServicePortal at http://support.mcafee.com.
- Type the article ID in the search field on the home page.
- Click Search or press Enter.
Use the following SQL command syntax to add the computer to the tree:
INSERT INTO ePOVirtualMacVendor (VendorID) values ('######')
(where: ###### is the first 6 digits of the VPN MAC address collected from the client in all caps)
Example
For a system with 00123F as the first six digits of the MAC address obtained in step 1:
INSERT INTO ePOVirtualMacVendor (VendorID) values ('00123F')
NOTE: After applying the solution, ePO still reports the clients MAC addresses as the Virtual MAC. The solution will prevent ePO from using MAC addresses with the vendor ID as valid matching criteria.
