Eliminating duplicate DNS entries

Toggle sidebar Toggle sidebar
dgingeri

dgingeri

Distinguished
Dec 4, 2009
2,123
1
20,460
I need some ideas on how to elimintate duplicate entries across several domains.

I have a big project I'm doing right now where I am merging 5 DNS domains into one. I have already exported all the domains, sorted, removed extraneous data, and saved them as a list in CSV files. I just have to go through all of them and make sure there are no duplicate names before I import them into the new DNS domain. Does anyone know of a tool, or how to use Excel in such a way, to find any duplicate names across the 5 lists I have?

(For instance, I know I have 3 entries for a system named Titan. If I import all the lists as they are now, the last one imported will have the final listing for Titan, overwriting the previously imported entries, but the reverse entries will still exist for all three, while the other two entries would be overwritten. This would leave me with some things to clean up.)
 
Sort by date Sort by votes
S

ss202sl

Glorious
May 23, 2012
8,431
35
44,190
Titan could live in more than 1 domain. You would need to use FQDN names to specify which specific titan machine you wanted to get to. having Titan in a test.domain as well as a Titan in the production.domain is valid, and you could get to either one by going to titan.test.domain, or titan.production.domain.
 
Upvote 0 Downvote
Hawkeye22

Hawkeye22

Glorious
Feb 10, 2006
11,442
1
49,065
You're welcome although I don't know if I'd call it smart. Smart would be writing a program to read in your five files and spit out duplicates. This is more of a necessity done with the bare minimum tools you most likely had on your computer already. ;)

Good luck with your project!
 
Upvote 0 Downvote
dgingeri

dgingeri

Distinguished
Dec 4, 2009
2,123
1
20,460


Didn't you know? Using a bare minimum of tools or programs to get the job done is a normal thing for admins. That's why so many go for Linux. I'm just lazier than most.
 
Upvote 0 Downvote
dgingeri

dgingeri

Distinguished
Dec 4, 2009
2,123
1
20,460
Forgot to post an update the other day. This worked perfectly. I merged the three files with just copy and paste into a final file, sorted them by name, then picked out the duplicates. Most were old entries for systems that had moved labs. All 5 zones are now merged into the new zone. I'm now about 10% through changing all the systems to use the new DNS domain and servers. 4592 entries in all, somewhat fewer systems.
 
Upvote 0 Downvote
You must log in or register to reply here.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom