Reply

Syntax error with .csv to delete PrtRecord

singram
Techie
Posts: 1
1772     0

I have many A & Ptr Records that are "orphaned" under a Host record after our conversion from MS-DNS and I would like to do a bulk delete rather than the 6 clicks for each record.  I have created the .csv based on the information in Infoblox-NIOS_CSV_Ref_8.0.pdf (page47) and used the examples and just can't figure it out.

So, any of you syntax masters that can help, my mouse would appreciate it.   Stan

 

CSV Import

Delete
    Delete rows in the imported file from the database

IB-remove-ptr-rec.2.csv
header-ptrrecord,dname*
ptrrecord,dal1-wn7-p023.inc.com
ptrrecord,dal1-wn7-p019.inc.com
header-ptrrecord,dname*,fqdn,address
ptrrecord,dal1-wn7-p023.inc.com,26.220.18.172.in-addr.arpa,172.18.220.26
ptrrecord,dal1-wn7-p019.inc.com,73.220.18.172.in-addr.arpa,172.18.220.73


csv-error.55.csv
Error,header-ptrrecord,dname*
"""Line 2: Deletion failed due to zone""",ptrrecord,dal1-wn7-p023.inc.com
"""Line 3: Deletion failed due to zone""",ptrrecord,dal1-wn7-p019.inc.com
Error,header-ptrrecord,dname*,fqdn,address
"""Line 5: Deletion failed due to The selected object could not be found""",ptrrecord,dal1-wn7-p023.inc.com,26.220.18.172.in-addr.arpa,172.18.220.26
"""Line 6: Deletion failed due to The selected object could not be found""",ptrrecord,dal1-wn7-p019.inc.com,73.220.18.172.in-addr.arpa,172.18.220.73

 

Re: Syntax error with .csv to delete PrtRecord

TTiscareno Community Manager
Community Manager
Posts: 361
1773     0

It looks like the header row does not contain the same number of columns as the object rows. Because there could be multiple PTR records with the same name or IP address, you will need to include the dname and address columns so that the system can parse these out properly. Here is a working example I just used to delete a PTR record:

 

header-ptrrecord,dname*,address
ptrrecord,ptr.test.zone,172.16.1.199

 

Regards,

Tony

Re: Syntax error with .csv to delete PrtRecord

[ Edited ]
Moderator bkoshy
Moderator
Posts: 130
1773     0

Additionally, since you mentioned HOST record, if the records you are referring to, exist as 'Host' in the reverse mapping zone and not as 'PTR', you would want to try the below format for the delete operation.

 

header-hostrecordfqdn*addresses
hostrecordabc.abc.local10.192.16.2



Note, that this would also remove the 'Host' from the forward mapping zone.

Best Regards,
Bibin Thomas

Showing results for 
Search instead for 
Do you mean 

Recommended for You

Businesses are investing heavily into securing company resources from cyber-attacks form cybercrimin