Frequency: 

Annual 

Prerequisites: 

• Book Of Knowledge Training 
• GTIPAM training 
• Training on using Python scripts. 
• Python installed on PC. 
• Knowledge of subnetting 

Steps 

1. Building Updated List 
   1. Note that extra Subnets will be removed by the script. 
   2. The list is created from the Book of Knowledge: https://bok.noc.gatech.edu/ 
   3. Choose Tools  
   4. Choose Free IP Locator 
   5. This will take many exports. Create a folder to save export to .csv files. 
      1. Network: 130.207.1.0   Netmask: /20   Days: 0 
      2. Network: 130.207.17.0   Netmask: /20   Days: 0 
      3. Network: 130.207.97.0   Netmask: /20   Days: 0 
      4. Network: 130.207.113.0   Netmask: /20   Days: 0 
      5. Network: 143.215.128.0   Netmask: /22   Days: 0 
      6. Network: 143.215.138.0 Netmask: /24   Days: 0 
      7. Network: 128.61.240.0 Netmask: /23   Days: 0 
      8. Network: 143.215.142.32 Netmask: /27   Days: 0 
      9. Network: 128.61.226.128 Netmask: /26   Days: 0 
      10. Network: 128.61.226.192 Netmask: /26   Days: 0 
      11. Network: 128.61.173.64 Netmask: /26   Days: 0 
   6. Save Python script from: https://it.github.gatech.edu/CoC-TSO/dnsreview
   7. The following edits need to be made in the script: 
      1. Line 112 (at time of writing) file_paths, replace file paths with saved files. If it is in the same folder as the script filename, it will suffice. If not, enter the entire file path. Ensure files are in quotes and separated with comma 
      2. Close to the bottom of the script, variable ddf (line 132) removes any entries that have DNS entries matching the IP address. As subnets change this may require modification 
      3. Any changes in COC subnets should be updated in subnets variable (line 11) 
      4. Line 78 is the variable for six months retention.  Add or remove subnets for grouping together. This is just a name as you change the time frame in a different line. 
      5. Line 86 mytime= 6 sets the time frame for six_month variable.  18 at the end sets anything not in the six_month variable to set thresh hold to 18 months. 
      6. Save script. 
   8. Run Script. DNSReview.xlsx will be generated in the same folder as the script.  Only subnets with entries will show in the sheet. 
   9. If using year as parameter, note that the year starts from day it is run 
   10. Review List with TSO as there may be DNS entries kept longer than 2 years for other reasons.  
   11. Save the list in DNS Cleanup Folder in Drobox with the date in the filename. EX. DNSReview5312023.xlsx 
   12. Archive older versions. 
2. Cleaning GTIPAM 
   1. Go to https://gtipam.dns.gatech.edu/ 
   2. Go to subnets that need work. 
      1. Left side go to IPAM then networks. Scroll to network or filter in ‘Address+prefix’ (ex. 130.207.17.0/24) and click on it. Note that at this point you can click star in top right of page to bookmark. Tip: name as subnet 
      2. Use bookmarks if previously saved by clicking down arrow next to star 
   3. Check the box to the left of the ip addresses for hostnames to remove 
   4. Select Delete icon (trashcan) at top of page (above address filter) 
   5. It will throw a warning that it will delete cname and aliases. Click “ok” 
   6. Mark the list of deleted and saved entries and save. 
      1. The list is a source of information in case an entry needs to be readded
   7. Ensure all teams and asset coordinator are updated as changes may need to be made to their documentation.