Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > User Device Tracker (UDT) > Obtain the switchport details on a MAC address in UDT

Obtain the switchport details on a MAC address in UDT

Table of contents

Updated May 24, 2017

Overview

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

Environment

All UDT version

Steps

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

 

Last modified

Tags

Classifications

Public