Reference: Bulk DNS update CSV file - BlueCat Address Manager - 9.1.0

Address Manager Administration Guide

Locale
English (United States)
Product name
BlueCat Address Manager
Version
9.1.0
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. For example:
action, recordname, TTL, recordtype, rdata, comment, user-defined field name=value, user-defined field name n=value,...
Lines in the file cannot be commented out. Each line contains the following columns:
Column Description
action The action to be performed on the record. Valid values are add, update, and delete. This column must be present and must contain a value.

add creates a new resource record.

update changes only the TTL, comment, and user-defined fields for most resource record types. For CNAME records, update changes only the host record to which the CNAME record points. For A records, update ignores any change made to the record’s IPv4 address.

delete deletes resource records. If a record is not found in Address Manager, a file-not-found error is logged in the server log, and error handling options Abort update and Skip records with errors and continue update have no bearing on this action. To delete records that contain multiple IP addresses, specify the address with an * asterisk.

recordname The name of the resource record. This column must be present and may or may not contain a value:'
  • When performing a bulk update at the zone level, this column can be blank to give the resource record the same name as the zone. The name of the record appears in Address Manager as (Same as Zone).
  • When performing a bulk update at the view level, this column must contain a value. Bulk DNS Update cannot create records with (Same as Zone) for the record name from the view level.
If your resource record names are controlled by a naming policy, you need to specify names that match the requirements of the policy. To specify an Incremental value in the CSV file, using the # (pound) symbol.

How you specify record names depends on from where you want to perform the bulk update:

  • When performing the bulk update at the view level, specify FQDNs. Address Manager assumes that all record names are not dot-separated.

    For example, add, host1.example.com., 3600, A, 192.168.0.2 adds the host record host1.example.com.

  • When performing the bulk update at the zone level, specify record names as relative names or FQDNs. Names ending with a dot are considered as absolute names which should not contain dot-separated names. Names not ending with a dot are considered as relative names and can contain a dot.

    For example, add, host2, 3600, A, 192.168.0.3 adds the host record host2.example.com.

    For example, add, host3.example.com., 3600, A, 192.168.0.4 adds the host record host3.example.com.

TTL The time-to-live value, in seconds, for the resource record. This column must be present but may be left blank. To leave a column blank, leave a space between the commas that delimit the column.
recordtype The type of resource record. Valid values are A, CNAME, MX, SRV, HINFO, TXT, and NAPTR. The following generic record types are also valid: A6, AAAA, AFSDB, APL, CAA, CERT, DHCID, DNAME, DS, IPSEC, ISDN, KEY, KX, LOC, MB, MG, MINFO, MR, NS, NSAP, PTR, PX, RP, RT, SINK, SPF, SSHFP, TLSA, WKS, and X25. This column must be present and must contain a value.
rdata The data to define the resource record. Where multiple parameters are specified for the rdata, the values are separated with a space. This column must be present and must contain a value.
comment A text string describing the resource record. After the record is added to Address Manager, this string appears in the Comments field when viewing the resource record’s Details tab. This column is optional. If you are adding user-defined fields to the record, this column must be present but may be left blank. To leave a column blank, leave a space between the commas that delimit the column.
user-defined field name The name and value for a user-defined field. This column is optional. You can add an unlimited number of user-defined field values in each line. The user-defined field must already exist in Address Manager. The name of the user-defined field must be specified exactly as it appears in Address Manager. The value must match the type of value defined for the field. For more information on user-defined fields, refer to Object types and user-defined fields.

Resource Record data

The rdata field contains the parameters for the resource record being added, updated, or deleted. When adding a record, these parameters define the record. When updating or deleting a record, these parameters are used to find the record to update or delete; all parameters must match an existing record for the record to be updated or deleted.
Record Type rdata
A Specify an IPv4 address for the host record.

For example: 192.168.188.200

CNAME Specify the host for the alias record.

For example: host1.example.com

MX Specify the priority and host name for the mail exchanger record, with a single space between each value:

For example: 10 mail.example.com

SRV Specify the priority, weight, port, and host for the service record, with a single space between each value.

For example: 10 50 5050 host1.example.com

To leave a value blank, use a 0 (zero) for the value.

In this example, the priority and weight values are set to 0 (zero): 0 0 5050 host1.example.com

HINFO Specify the central processor unit and operating system for the host information record, with a single space between each value. To include spaces in each value, the entire rdata string must be enclosed in “quotation marks”. Values that contain string must be enclosed in ““doubled”” quotation marks.

For example: """Dual 1.2Ghz"" ""Linux 7.1"""

TXT Specify the text string for the text record.

For example: This is a text record

NAPTR Specify the order, preference, flags service, regular expression, replacement, and for the naming authority pointer record.

For example: 100 10 A E2U+email !^.*$!mailto:information@example.com!i .

Generic record types Specify the rdata string for the record type. Refer to the respective RFC of each record type for the required rdata string.

CSV examples

To add a host record with a comment and user-defined field:

add, host1.example.com., 3600, A, 192.168.0.1, A Host record, Location=Toronto
To add a host record with no comment and with a user-defined field:
add, host2.example.com., 3600, A, 192.168.0.2, , Location=New York
To add a host record with multiple IPv4 addresses:
add, host3.example.com., 3600, A, 192.168.0.2
add, host3.example.com., 3600, A, 192.168.0.3
add, host3.example.com., 3600, A, 192.168.0.4
To add an SRV record with a blank port value:
add, srv.example.com., 3600, SRV, 10 0 50 host1.example.com, An SRV record
To add an AAAA record for an IPv6 address:
add, host4.example.com., 3600, AAAA, FD3B:4F43:E610:0:1322:33FF:FE44:5566
To update the TTL and comment for a host record:
update, host1.example.com., 7200, A, 192.168.0.1, Updated the TTL
To delete a host record that may have multiple IP addresses:
delete, host1.example.com., 7200, A, *