Network Management

Obtain the switchport details on a MAC address in UDT

This article provides steps needed in checking the database to get more details where a MAC address has been detected by UDT.

First published date

10/30/2018 8:58 PM

Last published date

6/22/2022 8:54 AM

Overview

This article provides steps to obtain the switchport details on a MAC address in the UDT database.

Product section

User Device Tracker

Resolution

Establish a remote desktop connection to the Orion server.
Launch the Database Manager.
Open the SolarWinds database.
Locate the following table named UDT_Endpoint and take note of the rogue MAC address and the EndpointID.
Open the following tables and cross check their EndpointID against the PortID data:
- UDT_Port2EndpointCurrent
- UDT_Port2EndpointHistory
Open the UDT_Port table and cross check the PortID .This is to get the NodeID.
Open the Nodesdata table and locate NodeID to get the name of the switch or router where the MAC address was polled against.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.