07-28-2017 09:32 AM
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
Delete rows in the imported file from the database
"""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
"""Line 5: Deletion failed due to The selected object could not be found""",ptrrecord,dal1-wn7-p023.inc.com,22.214.171.124.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,126.96.36.199.in-addr.arpa,172.18.220.73
07-31-2017 02:47 PM
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:
08-15-2017 01:49 PM - edited 08-15-2017 01:50 PM
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.
Note, that this would also remove the 'Host' from the forward mapping zone.