Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > User Device Tracker (UDT) > Add all Rogue Device MAC addresses to whitelist

Add all Rogue Device MAC addresses to whitelist

Table of contents

Updated December 27, 2017

Overview

This article provides guidance on building a bulk whitelist of the Rogue Devices based on MAC addresses.

Environment

  • UDT 3.2+

Steps

  1. Log in to the server UDT is installed on. 
  2. Open Database Manager and expand down to UDT database.
  3. Run the following query: SELECT * FROM [dbo].[UDT_Endpoint]
    where Rogue = 1
  4. Click the button Export to CSV. 
  5. Open the file in Excel.
  6. Format the document for comma delineation. 
  7. Copy the MAC addresses only from the MACAddresses column into a new Excel workbook and paste them in column A.
  8. Put the following formula in column B:

    =MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)

  9. Drag the formula down to apply to all rows. 

  10. Copy the data from column B into your whitelist.

 

 

Last modified

Tags

Classifications

Public