If I might recommend a commercial product - Men and Mice is a professional solution to such a problem:
http://www.menandmice.com/
I have no direct affiliation with them, but we're currently working with their product to manage our rat's nest of an IP scheme.