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 existing devices to whitelist such as MAC, IP, or Host name

Add all existing devices to whitelist such as MAC, IP, or Host name

Table of contents

Updated December 1, 2016

Overview

This article provides an easy way to ensure that all existing devices (MAC, IP or Host name) are added into the UDT whitelist. This is practically useful for Network/System Admins so that instead of adding one by one, this can be done in few easy steps.

Once the network devices has reached a stable state (meaning all known and approved IP MAC and hostname has been added to whitelist ) any new MAC, IP or Hostname are subject for review and approval by the Network/Systems Admin.

Environment

All UDT versions

Steps

  1. Access the Orion Database (RDP).
  2. Launch Database Manager and open the Solarwinds/Orion Database.
  3. Look for any or all of the below tables, depending on what you need:

    UDT_Endpoint

    UDT_EndpointIP

    UDT_EndpointDNS

  4. By Default, the query only shows 1000 entries. If you have a large environment, feel free to change the numeric value as you see fit:
SELECT TOP 10000 * FROM [dbo].[UDT_Endpoint] 
SELECT TOP 1000 * FROM [dbo].[UDT_EndpointIP]
SELECT TOP 1000 * FROM [dbo].[UDT_EndpointDNS]

 

  1. Click Export to CSV.

  2. Now that you have the Raw Data, open this file in MS Excel and edit this to only obtain the IP, MAC or Hostname Column. (Use Text to Column in Excel to separate the Data). Also make sure to use the Delete Duplicate entries in excel to ensure accuracy.

 

 

3. On the Orion web console go to Settings\UDT Settings\Manage White List.

4. Click on the "Add New" button

5. From the left panel, you can click on "Custom" for bulk change/edit

6. You can change the Target field based on your preferred information to be added in white list

7. Follow the wizard to save the changes.

 

Last modified

Tags

Classifications

Public