Create a report to find the MAC address of the VPN

Prev Next

To prevent MAC address duplication when systems connect through a VPN, first determine the MAC address of the VPN server. An alternative way to learn the MAC address is to create a report and identify the systems that share an address.

  1. Select MenuReportingQueries & Reports.

  2. Click New Query to display the Result Type tab, configure these settings:

    • In the Feature Group list, select System Management.

    • In Result Types pane, select Systems.

  3. Click Next.

  4. From the Chart tab, configure these settings:

    • In the Summary list, select Single Group Summary Table.

    • In the Labels list, under Computer Properties, select MAC Address.

  5. Click Next.

  6. In the Columns tab, from the Available Columns list under Computer Properties, select MAC Address, then click Next

  7. In the Filter tab, configure these settings:

    • In the Available Properties list, expand Systems and click Managed State.

    • In the Managed State settings, select Equals from the Comparison drop-down list and Managed from the Values drop-down list.

    • In the Available Properties list, expand Computer Properties and click MAC Address.

    • In the MAC Address settings, select Value is not Blank from the Comparison drop-down list.

  8. Click Run.

  9. In the output of the query, find any two systems with the same MAC address. This MAC address probably belongs to the VPN server connecting the systems to ePO - On-prem. Make note of the first six digits of the system MAC address, which is the OUI of the VPN server.

Use the OUI value in the SQL Server Management Studio to update the virtual MAC vendor ID.