Bulk DNS Update with CSV 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,...

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.

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