Data Mapping cfxdm - dm:dns_name_to_ip

DNS Name resolution from FQDN to IP Address

dm:dns_name_to_ip: It allows to resolve the FQDN names to IP addresses listed in a column into another column.

dm:dns_name_to_ip: Syntax

• from_cols (mandatory): Comma-separated list of column names which has DNS Name (FQDN) values

• to_cols (mandatory): Comma-separated list of column names to store resolved DNS Name (FQDN) names into IP Address.

• keep_value (optional): If it is set to 'yes', it stores the original value, else it stores the 'null' value. By default, it is set to 'no'

• num_threads (optional): Number of DNS lookup threads. Must be in the range of 1 to 20, Default is set to 5.

This tag uses the DNS servers configured on the host os where RDA is installed and running for IP Address to DNS or FQDN name resolution.

It requires an input dataset or a tag that has one or more columns with DNS Name (FQDN) values.

Example 1:

Step 1: Create an empty dm_dns_name_to_ip_example_1 using AIOps studio as shown in the below screenshot

Empty pipeline

Step 2: Add the following pipeline code/commands into the above-created pipeline as shown in the below screenshot:

You can copy the below code into your pipeline and execute that in your environment.

###### Pipeline creates a dataset with server fqdn and pid runtime ###### information on a windows box. ###### Pipeline uses dm:dns_name_to_ip function to resolve FQDN DNS name to ipaddress ###### dm function uses DNS server from RDA machine where it is installed @dm:empty --> @dm:addrow address = 'ec-test1.engr.cloudfabrix.com' & pid = 0 --> @dm:addrow address = 'dns-cfx-dc1.engr.cloudfabrix.com' & pid = 1020 --> @dm:addrow address = 'cfx-services-dep-01.engr.cloudfabrix.com' & pid = 1020 --> @dm:addrow address = 'cfxregistry.cloudfabrix.com' & pid = 1064 --> @dm:dns_name_to_ip from_cols = 'address' & to_cols = 'ip_address' & keep_value = 'yes'

Pipeline code added to the empty pipeline created above.

Step 3: Click verify button to verify the pipeline. RDA will verify the pipeline without any errors (as shown below)

Pipeline code verified for any errors

Step 4: Click execute button to execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

Pipeline executed without any errors as shown above screenshot

Step 5: Verify that the FQDN field as part of the dataset is resolved and print the IP Address using DNS resolution as shown in the below screenshot.

RDA executes pipeline and resolve FQDN to IP Address using DNS server as shown above screenshot