Skip to main content

MAC Vendor OUI & MikroTik DHCP Lease Conflict Inspector

Inspect bulk ARP tables and MikroTik DHCP leases, identify OUI vendors, detect randomized MACs, and catch duplicate IP network conflicts instantly.

Input Parameters

Try Example:

Calculation Results

Total Devices Scanned
5 Devices
Infrastructure Devices
3 Units
Randomized Privacy MACs
1 Clients
Duplicate IP Conflicts
0 Conflicts
Network Audit Status
BERSIH (0 Konflik IP Terdeteksi)
Want to compare 2 design options side-by-side (e.g., Scenario A vs Scenario B)?
⚡ Enterprise Network Infrastructure Standard
Managed L2+/L3 Gigabit Switch (802.1Q VLAN & RSTP) + Cat6/FO Uplink
RFC 1918 / RFC 4632 Compliant Addressing

Isolate management, server, user, and IoT/CCTV traffic into dedicated 802.1Q VLANs.

Network Hardware & Vendor Inventory Table
IP AddressPhysical MAC AddressOUI PrefixHardware ManufacturerClassified Device Role
192.168.88.148:8F:5A:11:22:33488F5AMikroTikRouter / Switch / AP
192.168.88.10BC:24:11:AA:BB:01BC2411Proxmox VE (QEMU/KVM)Virtual Machine / LXC
192.168.88.2144:19:B6:00:11:224419B6Hikvision DigitalIP Camera / NVR CCTV
192.168.88.2230:0D:9E:55:66:77300D9ERuijie / ReyeeCloud Managed AP / Switch
192.168.88.55DA:A1:19:12:34:56DAA119Randomized / Private MAC (iOS / Android Wi-Fi Privacy)Smartphone Klien (MAC Acak)
Share to WhatsApp

How to Use This Tool

  1. Paste your raw IP and MAC address table from MikroTik terminal (/ip dhcp-server lease print or /ip arp print) or plaintext rows into the input area.
  2. The parser automatically extracts MAC tokens, normalizes hexadecimal delimiters, and correlates OUI prefixes against the offline vendor database.
  3. Review the classified device inventory table, check automated role labels (Router, CCTV, AP, Hypervisor), and verify whether duplicate IP collisions exist.

Worked Example: 5 Network Devices Audit

Computed example: Scanning 5 DHCP lease rows accurately classifies a MikroTik Core (48:8F:5A), Proxmox VE hypervisor (BC:24:11), Hikvision IP Cam (44:19:B6), Ruijie AP (30:0D:9E), and 1 randomized privacy smartphone, with 0 IP collisions.

Example Input
IP & MAC Address List (Paste DHCP / ARP Table)
192.168.88.1 48:8F:5A:11:22:33 MikroTik-Core 192.168.88.10 BC:24:11:AA:BB:01 pve-node1 192.168.88.21 44:19:B6:00:11:22 IPCam-Lobby 192.168.88.22 30:0D:9E:55:66:77 AP-Ruijie-Lt1 192.168.88.55 DA:A1:19:12:34:56 iPhone-Guest
Calculated Output
Total Devices Scanned
5 Devices
Infrastructure Devices
3 Units
Randomized Privacy MACs
1 Clients
Duplicate IP Conflicts
0 Conflicts
Network Audit Status
BERSIH (0 Konflik IP Terdeteksi)
Network Hardware & Vendor Inventory Table
IP AddressPhysical MAC AddressOUI PrefixHardware ManufacturerClassified Device Role
192.168.88.148:8F:5A:11:22:33488F5AMikroTikRouter / Switch / AP
192.168.88.10BC:24:11:AA:BB:01BC2411Proxmox VE (QEMU/KVM)Virtual Machine / LXC
192.168.88.2144:19:B6:00:11:224419B6Hikvision DigitalIP Camera / NVR CCTV
192.168.88.2230:0D:9E:55:66:77300D9ERuijie / ReyeeCloud Managed AP / Switch
192.168.88.55DA:A1:19:12:34:56DAA119Randomized / Private MAC (iOS / Android Wi-Fi Privacy)Smartphone Klien (MAC Acak)

Core Concept & Engineering Notes

Managing local network device inventories through Media Access Control (MAC) physical addresses and DHCP lease analysis forms an essential daily discipline for network administrators, system engineers, and field technicians. An Ethernet MAC address spans 48 bits (6 hexadecimal octets) governed by the IEEE registration authority. The initial 24 bits (first three octets) constitute the Organizationally Unique Identifier (OUI), which conclusively identifies the hardware manufacturer—such as MikroTik RouterBOARD, Ubiquiti UniFi, Ruijie Reyee, Hikvision CCTV, Dahua, Proxmox VE, VMware ESXi, Cisco, or Espressif IoT microcontrollers. When performing site audits or diagnosing connectivity issues, extracting raw ARP tables or DHCP server lease dumps yields dozens or hundreds of ambiguous IP-to-MAC mappings lacking device hostnames. Manually querying external online OUI lookup APIs is tedious and leaks sensitive internal infrastructure telemetry to third-party cloud services. This bulk inspector processes raw text dumps 100% offline within the browser, cross-referencing OUI prefixes against a curated vendor database tailored for enterprise networks and automatically classifying device roles (e.g. Infrastructure Router, Wi-Fi AP, IP Camera, Hypervisor VM, or Client Endpoint). Beyond vendor classification, the inspector features a deterministic duplicate IP conflict detection engine. When an identical IP address is mapped to distinct physical MAC addresses within the same subnet, the engine raises an immediate critical alert flagging static IP collisions or malicious ARP poisoning. Additionally, the parser detects the IEEE Locally Administered Address (LAA) bit, identifying private randomized MAC addresses enabled by modern iOS and Android mobile operating systems for Wi-Fi privacy.

How It Was Calculated (Formulas & Steps)

Frequently Asked Questions (FAQ)

What is an Organizationally Unique Identifier (OUI) on an Ethernet MAC address?

An OUI is the first 24 bits (initial 3 hex octets) of a MAC address officially assigned by the IEEE to hardware manufacturers, guaranteeing globally unique network hardware identifiers.

How can network administrators distinguish authentic factory MACs from randomized MACs?

Examine the second nibble of the first octet. If the second character is 2, 6, A, or E (indicating the IEEE Locally Administered Address bit is set), the MAC is a randomized privacy address generated by iOS or Android devices.

How do you export DHCP leases directly from MikroTik RouterOS?

Access RouterOS CLI or Winbox Terminal and run: /ip dhcp-server lease print detail, or select and copy rows directly from the Winbox DHCP Server Leases window.

Why is duplicate IP conflict detection essential in production networks?

IP collisions occur when two devices claim the same IP address, resulting in severe ARP table flapping, gateway packet dropouts, and intermittent service downtime for mission-critical servers.

🔬 Scientific Methodology & Normative Verification

Engineering Sensitivity Analysis, Response Curve & Technical Citation

✓ Calibrated to ISO/IEC/IEEE/TIA Clauses

1. 1. 3-Point Engineering Sensitivity & Tolerance Envelope

Comparative evaluation across theoretical laboratory bounds (0% loss), current nominal operating point, and conservative field safety bounds (±15% thermal/aging derating).

Evaluated Parameter Ideal Theoretical Bound Nominal Operating Point Conservative Safety Bound (±15%) Engineering Derating Rule
Total Devices Scanned 4.5 5 5.75 Engineering Safety Margin (+15% Overhead)
Infrastructure Devices 2.7 3 3.45 Engineering Safety Margin (+15% Overhead)
Randomized Privacy MACs 0.9 1 1.15 Engineering Safety Margin (+15% Overhead)

2. 2. Mathematical Function Curve & Operating Coordinate (x₀, y₀)

MATHEMATICAL RESPONSE CURVE: TOTAL DEVICES SCANNED VS INPUT PARAM Conservative Engineering Bound (+15% Safety Margin) 4 6 8 10 12 14 16 (x₀=10, y₀=5) Variabel Independen (x): Input Param

3. 3. Physical Constants & Normative Standard Clauses

R_loop(Cat6, 20°C) = 14 Ω/100m ANSI/TIA-568.2-D & IEEE 802.3bt

DC Loop Resistance for 23 AWG Solid Copper Cat6

Clause 6.4.1 / Table 145-1 — Nominal 23 AWG solid copper loop resistance at 20°C is 14.0 Ω/100m (TIA maximum ceiling is 18.8 Ω/100m).

α_opt(1490nm) = 0.25 dB/km ITU-T Rec. G.652.D & G.984.2

Single-Mode Optical Fiber Attenuation Coefficient at 1490 nm

Table 1 / Class B+ & C+ Optical Path — Typical G.652.D attenuation at 1490 nm downstream is 0.22–0.25 dB/km (1310 nm upstream: 0.35 dB/km).

α_Cu(20°C) = 0.00393 °C⁻¹ IEC 60028

Temperature Coefficient of Resistance for Copper

International Annealed Copper Standard — Used in thermal derating equation: R(T) = R_20 × [1 + 0.00393 × (T - 20)].

4. 4. Independent Technical & Academic Citation (IEEE / APA 7th / BibTeX / LaTeX)

Use the standard citation formats below to reference this computational methodology in engineering specifications, audit reports, or academic papers.

Format IEEE & APA 7th Edition

[IEEE] InfraCalc Engineering Team, "MAC Vendor OUI & MikroTik DHCP Lease Conflict Inspector — Standard Engineering Computational Instrument," InfraCalc Technical Suite, 2026. [Online]. Available: https://infracalc.web.id/en/tools/mac-oui-dhcp-lease-inspector. [Accessed: 2026-11-08].

[APA 7th] InfraCalc Engineering Team. (2026). MAC Vendor OUI & MikroTik DHCP Lease Conflict Inspector (Production release 2026-11-08) [Engineering computational software]. InfraCalc. https://infracalc.web.id/en/tools/mac-oui-dhcp-lease-inspector

BibTeX & LaTeX Derivation Snippet
@software{infracalc_mac_oui_dhcp_lease_inspector_2026,
  author = {{InfraCalc Engineering Team}},
  title = {{MAC Vendor OUI & MikroTik DHCP Lease Conflict Inspector --- InfraCalc Engineering Suite}},
  year = {2026},
  publisher = {InfraCalc.web.id},
  url = {https://infracalc.web.id/en/tools/mac-oui-dhcp-lease-inspector},
  urldate = {2026-11-08}
}

% LaTeX Engineering Derivation — Generated via https://infracalc.web.id/en/tools/mac-oui-dhcp-lease-inspector
\begin{equation}
  \text{Model: } Vendor OUI = First 3 Octets (initial 24 hex bits assigned by IEEE Registration Authority)
\end{equation}
% Parameter Input Terukur: singleMacOrDump = 192.168.88.1 48:8F:5A:11:22:33 MikroTik-Core
192.168.88.10 BC:24:11:AA:BB:01 pve-node1
192.168.88.21 44:19:B6:00:11:22 IPCam-Lobby
192.168.88.22 30:0D:9E:55:66:77 AP-Ruijie-Lt1
192.168.88.55 DA:A1:19:12:34:56 iPhone-Guest
% Hasil Evaluasi Numerik : totalDevicesScanned = \mathbf{5}, \; infraDevicesCount = \mathbf{3}, \; randomizedPrivacyMacCount = \mathbf{1}