We have a Microsoft SBS 2011 server at work which handles DHCP and DNS for our company. We have an excel spreadsheet stored in a shared directory on the SBS itself of all the public IP addresses that we own. That excel document is updated constantly by us by hand. It would be nice if we could dynamically update our DNS server with short names for those IP addresses so that when someone using any machine on our domain pings, or tries to connect to one of those public IPs, all they need to write out is a short name instead of the entire IP.
Currently, I had Linux go through that excel document once using a bash loop, and generate a windows hosts file that people could copy manually into C:\Windows\System32\Drivers\etc\hosts. This worked great, but this would need to be copy pasted onto every machine in the domain, and it would not be dynamic - pretty much the reason DNS was invented.
Is there any way to have either our SBS, or maybe even Linux constantly go through the excel file and update the SBS AD DNS server with some simple records that point to public IPs? An example of a mapping might be:
123456r 188.8.131.52 123458r 184.108.40.206
I believe those are A records we need. It would be extremely preferable if we did not need to append any kind of domain name to those entries and just have them be as simple as those examples. What's a good way to accomplish this?