Bulk DNS Update with CSV or XML File

Introduction:

There was a port scanner attack on the printers with external DNS which cause them to print random printouts. In order to prevent this from happening again, the external DNS addresses for printers are to be removed. The following are instructions for the procedure to create a CSV file for bulk updates.

Bluecat (Proteus) allows bulk DNS updates with a CSV file.  Each line in the comma-separated value (CSV) file represents a resource record. A line break must follow each line, and the file may contain up to 5000 lines. The comma-separated values represent columns of data, but the CSV file must not contain column headings.

EXAMPLE: action, recordname, TTL, recordtype, rdata, comment, user-defined field, user-defined field name n=value,...

There is also an option to remove multiple DNS entries with XML file (sample provided below).

Instructions:

  Resource:

Here is the guide provided directly from BlueCat. This guide should be used as a reference for creating the CSV file with the proper functionality.

 Deleting External DNS:

Creating the CSV File:

The rundown for how the columns are formatted:

1^st – Action ; 2^nd – RecordName ; 3^rd – TTL; 4^th – RecordType; 5^th – Rdata

*Please refer to the guide to populate the fields with the proper information.

**Examples: delete, test.med.tufts.edu, , A, 130.64.64.64

                   delete, test2.med.tufts.edu, , A, 130.64.52.52

1. Once the CSV file has been completed; navigate to the DNS tab in Proteus.
2. Under Tufts Configuration Information, go to the Views tab.
3. Select ‘external’ under DNS Views.
4. This should navigate you to the Zones tab; click on Action and select Bulk DNS Updates.
5. Click on Browse and select the CSV file; hit next and review the updates.
6. Hit apply if there are no errors; the results will indicate how many entries have been updated/ignored.

Creating XML file:

It is possible to remove host records from the external view while leaving the internal view intact. Below is a sample xml file that will remove the three printer records specified. Note that the XML file specifies the view, the full domain, and a list of host names and IP addresses (the addresses are required) along with the directive "delete" for each host. You can add more <host> lines as needed.

<?xml version="1.0" encoding="utf-8"?>

<\!DOCTYPE data PUBLIC "-//BlueCat Networks/Proteus Migration Specification 3.7.1//EN" "[http://www.bluecatnetworks.com/proteus-migration-3.7.1.dtd|http://www.bluecatnetworks.com/proteus-migration-3.7.1.dtd]">

<data>

<configuration name="Tufts">

<view name="external">

<zone name="edu" deployable="false">

<zone name="tufts" deployable="true" on-exist="ignore">

<zone name="med" deployable="true" on-exist="ignore">

<host name="bmedcidpr1" address="130.64.55.43" on-exist="delete"/>

<host name="bmedcidpr2" address="130.64.55.44" on-exist="delete"/>

<host name="bmedcidpr3" address="130.64.55.50" on-exist="delete"/>

</zone>

</zone>

</zone>

</view>

</configuration>

</data>

Ensure all entries have no errors; if there is an error, either modify the line with the proper information or remove it entirely.