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


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


  • UDT 3.2+


  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:


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

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



Last modified