If the computers have already connected via a VPN, create an entry in the ePOVirtualMacVendor table with the Organization Unique Identifier (OUI), which is part of the VPN MAC address:
- Determine the VPN MAC address that must be added 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. Then, remove 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.
-
To view its properties, double-click the computer.
-
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 can't 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.
- From 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 that report that particular MAC address. Ideally, it would be a one-to-one ratio. If you have more than one system sharing the MAC address, that is probably your issue.
- To add the computer to the tree, modify the SQL script:
NOTE: For more information about running SQL scripts 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 ('######')
In the above command, ###### is the first six 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 prevents ePO from using MAC addresses with the vendor ID as valid matching criteria.
